Assignment statistics

maigc
module3m.xlsx

(1) 68-95-99.97%

Payments Due Mean SD
8000 ? ?
8500
7600
9000
8600
5900 Q1: Based on the given sample data, 68% of all payments will fall between: ? ?
9000 Q2: Based on the given sample data, 95%% of all payments will fall between: ? ?
7900 Q3: Based on the given sample data, 99.97%% of all payments will fall between: ? ?
6788 Q4: Using data analysis tools, do the LCI and UCI for a 95% confidence interval:
9867
8888
7765
6509
1000
8000
9000
7278
7283
8773
7488
8657
8049
7847
8701
8195
8698
8617
7505
7189
7146
7252
8819
7776
7081
7843
7152

(2) Z and highlight Outliers

Case Payments Due Z score Mean SD
1 9430 ? ? ?
2 8500 ?
3 7600 ?
4 9000 ?
5 8600 ?
6 5900 ?
7 10000 ?
8 7900 ?
9 6788 ?
10 9867 ?
11 8888 ?
12 7765 ?
13 6509 ?
14 1000 ?
15 800000 ?
16 9000 ?
17 7278 ?
18 7283 ?
19 8773 ?
20 7488 ?
21 8657 ?
22 8049 ?
23 7847 ?
24 8701 ?
25 8195 ?
26 8698 ?
27 8617 ?
28 7505 ?
29 7189 ?
30 7146 ?
31 7252 ?
32 8819 ?
33 7776 ?
34 7081 ?
35 7843 ?
36 715200 ?

(3) Normal function

Payments Due Mean SD
8000 ? ?
8500 Please use the data on the left to calculate the mean and SD and then use them to answer the following:
7600
9000 What is the probability that a randomly selected amount due will be:
8600
5900 Q1 less than 5000 ? ?
9000
7900
6788 Q2 more than 5000 ? ? Hint: Please note for this problem, you first need to find less than 5000 and subtract that value out of 1
9867
8888
7765 Q3 less than 9500 ?
6509
1000
8000 Q4 less than 7000 ?
9000
7278
7283 Q5 more than 10,000 ? Hint: Please note for this problem, you first need to find less than 10,000 and subtract that value out of 1
8773
7488
8657
8049
7847
8701
8195
8698
8617
7505
7189
7146
7252
8819
7776
7081
7843
7152