statistics

profilemomansour
  • 6 months ago
  • 10
files (1)

DataAnalyticsExamProposal.xlsx

Ex 1 and 2

N of observation Package size in grams
1 984
2 1037
3 1017 Exercise 1 (30 points)
4 1012 You are producing cornflakes and there is a new law that requires you to publish on the package 99% confidence interval for the weight of the cornflakes pack.
5 1012 Assume that population standard deviation (aka sigma) is known and equal to 25 grams.
6 1041 Construct 99% confidence interval and briefly interpret it with 1-2 sentences.
7 980
8 1028 Exercise 2 (30 points)
9 960 You are producing cornflakes and there is a new law that requires you to publish on the package 99% confidence interval for the weight of the cornflakes pack.
10 1032 Assume that population standard deviation is not known and you need to estimate it using the sample data.
11 981 Construct 95% confidence interval and briefly interpret it with 1-2 sentences
12 982
13 1016
14 972
15 982
16 986
17 1018
18 1047
19 964
20 969
21 972
22 1018
23 1005
24 969
25 975
26 1004
27 987
28 1026
29 966
30 952
31 1009
32 997
33 974
34 959
35 1001
36 1012
37 1039
38 1037
39 993
40 964
41 951
42 987
43 977
44 961
45 1029
46 1015
47 954
48 1004
49 985
50 1035
51 978
52 1008
53 1026
54 1042
55 980
56 1049
57 1025
58 1029
59 1007
60 1048
61 979
62 968
63 973
64 1020
65 976
66 1013
67 1009
68 968
69 1033
70 970
71 954
72 1011
73 952
74 1026
75 1027
76 1002
77 1004
78 963
79 1034
80 1034
81 957
82 1013
83 965
84 954
85 976
86 950
87 951
88 996
89 1037
90 996
91 1041
92 951
93 998
94 1036
95 1041
96 1050
97 996
98 1039
99 1000
100 959

Ex 3

N of observation Price per liter of gasoline, EUR
1 1.8
2 1.66 Exercise 3 (40 points)
3 1.73 The prime minister of one european country said that the average gasoline price in his country is 1.7 EUR.
4 1.76 His opponents claim that the true (population) gasoline price is higher than 1.7 EUR due to elevated inflation.
5 1.82 Assume the population standard deviation is known and it is 0.06 EUR.
6 1.78 Test the null hypothesis that the population average (mu) gasoline price is 1.7
7 1.7 against one-sided alternative that population average gasoline price is bigger than 1.7 EUR.
8 1.75 Use alpha=0.01 and critical value approach.
9 1.82 Interpret the result in 1-2 sentences.
10 1.83
11 1.82
12 1.85
13 1.78
14 1.68
15 1.82
16 1.71
17 1.82
18 1.67
19 1.8
20 1.74
21 1.69
22 1.65
23 1.77
24 1.74
25 1.78
26 1.67
27 1.76
28 1.8
29 1.78
30 1.74
31 1.69
32 1.83
33 1.72
34 1.76
35 1.82
36 1.74