Standard Deviation Normal Probability Calculations Statistics Worksheet

User Generated

qrzzjvyfba

Mathematics

Description

  1. Complete the problem included in the file WS3AppliedStatistics (Excel). Follow the directions in the worksheet to create:
    1. A mean and standard deviation
    2. Normal probability calculations using Excel functions
  2. Using Microsoft Word, write a brief paragraph explaining a scenario where you might employ the tools learned in this workshop to help solve a managerial problem in the workplace. Save your work and submit it along with your completed Excel file for this exercise. Name your Word file WS3_AppliedScenario.docx. Save your exercises as a single Excel file with one worksheet for each completed exercise. Name the file WS3AppliedStatistics.xlsx and title your submission WS3 Applied Statistics.

Unformatted Attachment Preview

PULSE 78 80 68 56 76 78 78 90 96 60 98 66 100 76 64 82 62 72 78 74 90 90 68 72 82 72 78 104 62 72 72 88 74 72 82 78 78 98 72 64 Mean Stdev ( 7.5 points) ( 7.5 points) Bell Curve 0 0,2 0,4 0,6 0,8 Source: Essentials of Statistics by Mario Triola Access these helpful videos: Video Video Video 1 DIRECTIONS: Find the probabilities. =NORMDIST() Questions: Probabillity of X less than 60 beats? (5 points, use 4 decimal places after the period) Probabillity of X greater than 80 beats? (5 points, use 4 decimal places after the period) Probabillity of X between 60 and 80 beats? (5 points, use 4 decimal places after the period) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! 0 0 0 0 0 0 0 #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM!
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

View attached explanation and answer. Let me know if you have any questions.

PULSE
78
80
68
56
76
78
78
90
96
60
98
66
100
76
64
82
62
72
78
74
90
90
68
72
82
72
78
104
62
72
72
88
74
72
82
78
78
98
72
64

Mean
Stdev

77.50 ( 7.5 points)
11.55 ( 7.5 points)

Bell Curve

0

20

40

60

80

100

Source: Essentials of Statistics by Mario Triola
Access these helpful videos:
Video
Video
Video

120

DIRECTIONS:
Find the probabilities. =NOR...

Related Tags