Question

In: Statistics and Probability

In the Excel file Restaurant Sales, determine if the variance of weekday (M/T/W/T/F) sales is different...

In the Excel file Restaurant Sales, determine if the variance of weekday (M/T/W/T/F) sales is different from that of weekend (S/S) sales with significance level of 5% for the variable delivery sales.

Date Day Lunch Sales $ Dinner Sales $ Delivery Sales $
1-Apr Saturday $542.00 $1,468.00 $884.00
2-Apr Sunday $873.00 $1,345.00 $489.00
4-Apr Tuesday $289.00 $646.00 $321.00
5-Apr Wednesday $354.00 $782.00 $289.00
6-Apr Thursday $403.00 $805.00 $276.00
7-Apr Friday $442.00 $1,289.00 $1,242.00
8-Apr Saturday $449.00 $1,652.00 $782.00
9-Apr Sunday $697.00 $1,209.00 $341.00
11-Apr Tuesday $307.00 $579.00 $328.00
12-Apr Wednesday $387.00 $664.00 $301.00
13-Apr Thursday $412.00 $891.00 $243.00
14-Apr Friday $508.00 $1,178.00 $1,068.00
15-Apr Saturday $503.00 $1,581.00 $714.00
16-Apr Sunday $741.00 $1,137.00 $326.00
18-Apr Tuesday $298.00 $572.00 $365.00
19-Apr Wednesday $419.00 $621.00 $278.00
20-Apr Thursday $345.00 $913.00 $294.00
21-Apr Friday $467.00 $1,332.00 $1,254.00
22-Apr Saturday $622.00 $1,732.00 $636.00
23-Apr Sunday $846.00 $1,324.00 $319.00
25-Apr Tuesday $233.00 $523.00 $411.00
26-Apr Wednesday $341.00 $731.00 $243.00
27-Apr Thursday $426.00 $940.00 $350.00
28-Apr Friday $379.00 $1,409.00 $1,143.00
29-Apr Saturday $592.00 $1,856.00 $601.00
30-Apr Sunday $779.00 $1,229.00 $398.00

Solutions

Expert Solution



Related Solutions

T/F -Variance is a measure of the variability of returns, and since it involves squaring the...
T/F -Variance is a measure of the variability of returns, and since it involves squaring the deviation of each actual return from the expected return, it is always larger than its square root, the standard deviation. -If an investor owns two stocks, one whose standard deviation is 0.21 and the other whose standard deviation is 0.10, the required return could be higher on the stock with the lower standard deviation. -Different investors have different degrees of risk aversion but this...
Given ACi = f (qi, w, v, t) where t is technology and technology is cost-reducing,...
Given ACi = f (qi, w, v, t) where t is technology and technology is cost-reducing, as t increases: A)    What will be the long run effect on market price, P, and quantity, Q, and the number of firms in the industry, N, if it is a constant cost industry. Draw a graph of the long run supply and demand. On what will the size of the change in Q depend? B)    If this is an increasing cost industry, how...
The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing...
The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identification number, sales region, item number, item description, unit price, units sold, and month when the sales were made during the fourth quarter of last year.3 Modify the spreadsheet to calculate the total sales revenue for each of the eight stores as well as each of the three sales regions.
6.(a) Show that if f : [a,b]→R is Riemann integrable and if m ≤ f (t)...
6.(a) Show that if f : [a,b]→R is Riemann integrable and if m ≤ f (t) ≤ M holds for all t in the subinterval [c,d] of [a,b], then m(d −c) ≤ ∫cd f(t) dt ≤ M(d −c). (that is supposed to be f integrated from c to d) (b) Prove the fundamental theorem of calculus, in the form given in the Introduction to this book. (Hint: Use part (a) to estimate F(x)−F(x0)/x−x0.)
T/F The variance of an asset's return can be less than the standard deviation of that...
T/F The variance of an asset's return can be less than the standard deviation of that asset's return. If an investor owns two stocks, one whose standard deviation is 0.21 and the other whose standard deviation is 0.10, the required return will be higher for the stock with the higher standard deviation. Different investors have different degrees of risk aversion, and the result is that investors with greater risk aversion tend to hold securities with lower risk (and therefore a...
Using the data in the Excel file Cell Phone Survey, determine if the mean response for...
Using the data in the Excel file Cell Phone Survey, determine if the mean response for Customer Service rating is different for the carriers (consider only AT&T, Verizon, and Sprint) for significance level of 5%. Gender   Carrier   Type   Usage   Signal strength   Value for the Dollar   Customer Service M   AT&T   Smart   High   5   4   4 M   AT&T   Smart   High   5   4   2 M   AT&T   Smart   Average   4   4   4 M   AT&T   Smart   Very high   2   3   3 M   AT&T   Smart   Very...
Consider the following. optimize f(t, w) = 5t − t2 + 2w − w2 subject to...
Consider the following. optimize f(t, w) = 5t − t2 + 2w − w2 subject to g(t, w) = 2t + w = 14 (a) Write the Lagrange system of partial derivative equations. (Enter your answers as a comma-separated list of equations. Use λ to represent the Lagrange multiplier.) (b) Locate the optimal point of the constrained system. (t, w, f(t, w)) =    (c) Identify the optimal point as either a maximum p
Using Excel, plot the internal temperature of a computer chip k=1.38 W/(m-K) that generated 2,000 W of power.
Using Excel, plot the internal temperature of a computer chip k=1.38 W/(m-K) that generated 2,000 W of power. The chip is 10 cm wide. Assume one side is at 40oC and the other is at 45oC
Let {W(t),t≥0} be a standard Brownian motion and let M(t)=max0≤s≤tW(s). Find P(M(9)≥3).
Let {W(t),t≥0} be a standard Brownian motion and let M(t)=max0≤s≤tW(s). Find P(M(9)≥3).
1. How is an Analysis of Variance (ANOVA) similar to and different from a t-test for...
1. How is an Analysis of Variance (ANOVA) similar to and different from a t-test for two samples? 2. Why is it impossible to calculate a negative F value when using an Analysis of Variance to test a hypothesis? Please answer both questions
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT