Mathematics Homework Help

Deviation Standard Normal Distribution Statistics Probability Calculations

 

  1. In your textbook, Essentials of Statistics, read:
    1. Chapter 6, Section 1: “The Standard Normal Distribution”
    2. Chapter 6, Section 2: “Real Applications of Normal Distributions”
  2. Watch the following videos explaining the Excel skills you will need to complete the problems. Note that the version of Excel presented in the video may differ from the one you are using.
    1. Normal Distribution Lecture
    2. Normal Dist Functions B
  3. Open the file WS3Practice (Excel). Follow the directions in the worksheet to create:
    1. A mean and standard deviation
    2. Normal probability calculations using Excel functions
  4. Save your exercises as a single Excel file. Name the file WS3Practice.xlsx