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 |