staticstics

profileshanta75
7DM20404C32141449Staticsticsedit.xlsx
Home>Business & Finance homework help>Accounting homework help>staticstics

Sheet1

Dollars spent
10 Part a
71 Mean 40.81
21
61 Part b
33 Standard Deviation 23.10
37
34 Part c
42 Degrees of Freedom 15.00
51
15 Lower Limit Critical Chi-square -6.26
16
96 Upper Limit Critical Chi-square 27.49
42
33 The 95% confidence interval
64 C.I Lower Limit 28.50
27 C.I Upper Limit 53.12

Sheet2

Dollars Spent
14 a
66 Mean 42
25
65 b
34 Standard Deviation 23.1689447321
38
31 c
47 95% Confidence Interval
54 C.I Lower Limit 29.6541408199
16 C.I Upper Limit 54.3458591801
15
99
44
31
65
28

Sheet3

Company Price Change ($) Part a
Aflac 0.8 variance 0.4335243056
Bank of Am 1.44
Cablevision -0.04 Part b
Diageo 0.9 Standard Deviation 0.6877
Fluor Cp 0.42
Goodrich 0.19 Part c
John $ John 1.31 Degrees of Freedom 11.0000
Loews Cp 0.98
Nokia 2.37
SmpraEngy 0.52 Left-tailed probability 3.8157
Sunoco 0.28 Right-tailed Probability 21.9200
Tyson Food 0.12
95% confidence interval of the population variance
C.I Lower Limit 0.2176
C.I Upper Limit 1.2498
The 95% confidence interval of the standard deviation
C.I Lower Limit 0.3208
C.I Upper Limit 0.7688

Sheet4

Satisfaction Score
96 Part a
90 Mean 84.1333 WRONG ANSWER
81
75 Part b
95 Variance 98.1156
99
80 Part c
82 Standard Deviation 10.2530
81
90 Part d
86 Degrees of Freedom 14.0000
80
95 Hypothesized Standard Deviation 12.0000
67
65 Chi-square Test Statistics 11.9618 5.6287 Lower limit
26.1189 Upper Limit
Lower-Tail P-value 0.8269
Upper-Tail P-value 0.1731
Two-Tail P-value 0.9804
Can the hypothesis be rejected? Can be rejected

Sheet5

Car Age and Repair Cost ($) F-Test Two-Sample for Variances
4 years 2 years
777 634 4 years 2 years
839 431 Mean 784.7692307692 451.0434782609
778 454 Variance 29444.2646153846 14041.2252964427
791 404 Observations 26 23
884 394 df 25 22
791 713 F 2.0969868365
775 573 P(F<=f) one-tail 0.0417450387
943 469 F Critical one-tail 2.0196443442
1013 155
944 433
1060 399
405 524
955 396
874 548
905 407
336 598
733 391
654 336
507 370
823 455
708 356
808 365
898 569
790
801
612

1. Null hypothesis: Variance of sample 1 is less than or equal to variance of sample 2 Alternative hypothesis : Variance of sample 1 is greater than variance of sample 2 2. Test statistic = 2.10 Critical Value = 2.02 P-value = 0.0417 The null hypothesis should be rejected