24 Jan You have just opened a restaurant in a large city, and you are deciding what you should charge for a regular-sized soda. You’d like to charge a price equal to the average of your competit
Activity I – You have just opened a restaurant in a large city, and you are deciding what you should charge for a regular-sized soda. You'd like to charge a price equal to the average of your competitors, which you believe is $2.58. To inform your decision, you want to learn more about the average price charged by competing restaurants in the area. You know you won't be able to get prices for every restaurant, so you randomly sample 35 and collect their soda prices. These data are in Soda.xlsx (See the attached)
- You are assuming the mean soda price is $2.58 for all of your competitors. When conducting data analysis to test this belief, what is this assumption called?
- Calculate the t-statistic assuming the mean soda price for all of your competitors is $2.58.
- Calculate the p-value for your t-statistic.
- Using a confidence level of 90%, test whether the mean soda price of all your competitors is $2.58 using the t-stat.
- Using a confidence level of 90%, test whether the mean soda price of all your competitors is $2.58 using the p-value.
- Is it possible that your answers to parts d and e would yield different conclusions?
Activity II – To better assess your willingness-to-pay for advertising on others’ websites, you want to learn the mean profit per visit for all visits to your website. To accomplish this, you have collected a random sample of 4,738 visits to your website over the past six months. This sample includes information on visit duration and profits. The data are contained in WebProfits.xlsx (See the attached) Using the data in WebProfits.xlsx:
- Build a 99% confidence interval for the mean profit per visit for all of your visitors.
- Let the null hypothesis be that mean profit per visit for all of your visitors is $11.50.
- Calculate the corresponding t-stat for this null hypothesis.
- Calculate the corresponding p-value for this null hypothesis.
- With strength of 95%, decide whether or not to reject this null hypothesis.
- Detail the reasoning behind your decision.
Sheet1
Restaurant | Soda Price |
1 | $2.39 |
2 | $3.37 |
3 | $2.63 |
4 | $2.80 |
5 | $3.06 |
6 | $2.37 |
7 | $2.37 |
8 | $3.52 |
9 | $2.73 |
10 | $2.66 |
11 | $3.04 |
12 | $2.82 |
13 | $3.10 |
14 | $1.98 |
15 | $3.57 |
16 | $2.98 |
17 | $3.53 |
18 | $3.43 |
19 | $2.94 |
20 | $3.61 |
21 | $2.56 |
22 | $3.64 |
23 | $3.37 |
24 | $2.59 |
25 | $3.66 |
26 | $2.90 |
27 | $2.67 |
28 | $3.16 |
29 | $3.12 |
30 | $3.19 |
31 | $2.58 |
32 | $3.10 |
33 | $2.75 |
34 | $2.88 |
35 | $3.75 |
Sheet2
Sheet3
,
Sheet1
Visitor | Duration | Profit |
1 | 2 | 1 |
2 | 7 | 16 |
3 | 5 | 1 |
4 | 8 | 1 |
5 | 16 | 1 |
6 | 8 | 1 |
7 | 9 | 1 |
8 | 6 | 1 |
9 | 5 | 1 |
10 | 28 | 1 |
11 | 3 | 1 |
12 | 5 | 19 |
13 | 12 | 1 |
14 | 10 | 17 |
15 | 10 | 1 |
16 | 15 | 1 |
17 | 21 | 1 |
18 | 10 | 47 |
19 | 20 | 22 |
20 | 4 | 1 |
21 | 10 | 16 |
22 | 9 | 1 |
23 | 6 | 23 |
24 | 8 | 1 |
25 | 6 | 1 |
26 | 8 | 18 |
27 | 5 | 1 |
28 | 2 | 1 |
29 | 14 | 29 |
30 | 10 | 1 |
31 | 7 | 1 |
32 | 12 | 1 |
33 | 3 | 1 |
34 | 7 | 22 |
35 | 9 | 1 |
36 | 4 | 10 |
37 | 5 | 28 |
38 | 12 | 1 |
39 | 11 | 22 |
40 | 5 | 1 |
41 | 5 | 1 |
42 | 10 | 1 |
43 | 21 | 1 |
44 | 7 | 1 |
45 | 5 | 1 |
46 | 6 | 19 |
47 | 7 | 1 |
48 | 4 | 22 |
49 | 4 | 34 |
50 | 11 | 1 |
51 | 8 | 1 |
52 | 6 | 36 |
53 | 12 | 1 |
54 | 8 | 1 |
55 | 5 | 1 |
56 | 11 | 1 |
57 | 13 | 1 |
58 | 7 | 1 |
59 | 5 | 1 |
60 | 6 | 1 |
61 | 11 | 1 |
62 | 8 | 26 |
63 | 3 | 1 |
64 | 12 | 33 |
65 | 11 | 1 |
66 | 23 | 13 |
67 | 6 | 1 |
68 | 9 | 30 |
69 | 12 | 17 |
70 | 5 | 1 |
71 | 8 | 31 |
72 | 4 | 18 |
73 | 6 | 1 |
74 | 8 | 12 |
75 | 4 | 28 |
76 | 15 | 21 |
77 | 11 | 1 |
78 | 4 | 1 |
79 | 5 | 1 |
80 | 8 | 1 |
81 | 6 | 22 |
82 | 4 | 25 |
83 | 11 | 24 |
84 | 8 | 22 |
85 | 5 | 26 |
86 | 7 | 1 |
87 | 5 | 1 |
88 | 11 | 22 |
89 | 9 | 41 |
90 | 10 | 1 |
91 | 9 | 1 |
92 | 9 | 1 |
93 | 11 | 1 |
94 | 1 | 1 |
95 | 9 | 1 |
96 | 7 | 1 |
97 | 5 | 25 |
98 | 9 | 1 |
99 | 7 | 11 |
100 | 16 | 1 |
101 | 6 | 17 |
102 | 5 | 17 |
103 | 11 | 1 |
104 | 3 | 1 |
105 | 6 | 1 |
106 | 4 | 1 |
107 | 6 | 24 |
108 | 7 | 1 |
109 | 14 | 18 |
110 | 6 | 1 |
111 | 5 | 1 |
112 | 10 | 1 |
113 | 6 | 1 |
114 | 8 | 1 |
115 | 8 | 17 |
116 | 17 | 1 |
117 | 9 | 1 |
118 | 10 | 1 |
119 | 5 | 1 |
120 | 9 | 1 |
121 | 4 | 26 |
122 | 7 | 1 |
123 | 10 | 24 |
124 | 14 | 26 |
125 | 12 | 34 |
126 | 3 | 14 |
127 | 9 | 1 |
128 | 10 | 1 |
129 | 10 | 20 |
130 | 4 | 1 |
131 | 4 | 1 |
132 | 6 | 1 |
133 | 15 | 34 |
134 | 5 | 1 |
135 | 5 | 28 |
136 | 15 | 1 |
137 | 10 | 15 |
138 | 6 | 24 |
139 | 6 | 1 |
140 | 8 | 1 |
141 | 12 | 25 |
142 | 11 | 1 |
143 | 4 | 1 |
144 | 6 | 1 |
145 | 5 | 26 |
146 | 10 | 22 |
147 | 6 | 1 |
148 | 10 | 1 |
149 | 6 | 1 |
150 | 2 | 1 |
151 | 10 | 18 |
152 | 7 | 1 |
153 | 10 | 13 |
154 | 11 | 1 |
155 | 12 | 28 |
156 | 8 | 1 |
157 | 15 | 1 |
158 | 8 | 1 |
159 | 3 | 1 |
160 | 9 | 1 |
161 | 5 | 32 |
162 | 17 | 29 |
163 | 6 | 1 |
164 | 9 | 21 |
165 | 12 | 1 |
166 | 12 | 1 |
167 | 5 | 1 |
168 | 8 | 1 |
169 | 8 | 34 |
170<
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline. Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax. About WridemyWe are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers. How It WorksTo make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline. Are there Discounts?All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure. Hire a tutor today CLICK HERE to make your first orderRelated TagsAcademic APA Writing College Course Discussion Management English Finance General Graduate History Information Justify Literature MLA |