Practice 13 use the t symbols in the margin to expand question details use the -

Question

Practice 13 use the t symbols in the margin to expand question details use the -symbol to hide details) 2 1 Analytics 3 a Generate a Descriptive Statistics report for Store 1 and Store 2 Demand. 4 b What percent of Store 1 Demand values are less than or equal to the MEAN Store 2 Demand? percent inc 5 c What percent of Store 2 Demand values are greater than the MEAN Store 1 Demand? 1-percen 6 2 Forecasting 7 a Create a Scatter Chart to compare Store 2 Sales Price to Store 2 Demand. 8 b Modify the scatter chart: remove chart title, add axis titles "x and "y 9 c Insert trendlines on the scatter chart for linear, polynomial, and exponential trends, Display equations on the chart. 10 d Use trendline equations as well as the TREND and GROWTH functions to predict Store 2 Demand based on historical Store 2 Sales Price values. 11 e Calculate the Absolute Error (absolute difference) between the forecasted values and the actual Store 2 Demand values. 12 f Which forecast method has the Minimum MEAN Absolute Error? 13 g Use this method to predict Store 2 Demand if the Sales Price $10.50. 15 Historical Data ANALYTICS: Store 1 and Store 2 Demand week store 1 Sales Price store 2 Sales Price store 1Demand store 2 Demand Store Demand K- MEAN Store 2 Demand 16 Store 2 Demand MEAN Store 1Demand 17 $5.35 $5.08 89 94 18 $6.64 $8.76 19 20 4 $15.58 21 $8.21 $10.68 22 $6.26 $11.40 23 $5.72 $6.96 24 $7.57 $14.90 25 $7.48 $6.06

Explanation / Answer

1) Answer to first question is:-

A) The table contain 20 entries for each store 1 and store 2 demand having sales price details for each entry. BY looking at the entries it seems the data oc a month and needs yo be anslaysed for some purpose.

B) The mean value of store 2 demand is 78.8 and according to question 35 % of store 1values are<=mean store 2 demand values

C)The mean value of store 1demand is 65.5 and according to question 75% of store 2 values are >= mean store 1 demand values

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.