Logo
Home Study Material Contact Search
AI Chat FREE
  1. sciences
  2. physics
  3. please post answers in excel showing all formulas

Please post answers in excel showing all formulas used. Refer to the gasoline sales time series...

70.2K

Verified Solution

Question

Physics

Please post answers in excel showing all formulas used.

Refer to the gasoline sales time series data in the giventable.

WeekSales (1000s of gallons)
118
221
319
422
518
616
720
819
923
1019
1116
1222
  1. Compute four-week and five-week moving averages for the timeseries. Round your answers to two decimal places.

    Week
    Sales    		4-Week
    Moving Average    		5-Week
    Moving Average
    118
    221
    319
    422
    518
    616
    720
    819
    923
    1019
    1116
    1222
  2. Compute the MSE for the four-week and five-week moving averageforecasts. Round your intermediate calculations and final answersto two decimal places.

    MSE for four-week moving average =  

    MSE for five-week moving average =
  3. What appears to be the best number of weeks of past data(three, four, or five) to use in the moving average computation?Recall that MSE for the three-week moving average is 9.

Answer & Explanation Solved by verified expert
4.1 Ratings (509 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

What role did observation of carbon dioxide play in this study?a. It acted as a...

Biology
Q

Describe in 175 words please type response: Describe statistical inference and how it corralates with hypothesis testing...

Basic Math
Q

For the following reaction, 15.1 grams of nitrogen monoxide are allowed to react with 5.41 grams...

Chemistry
Q

List the factors influencing worker motivation that are under managers' control (Submits a thorough explanation of more...

General Management
Q

Five Measures of Solvency or Profitability The balance sheet for Garcon Inc. at the end of...

Accounting
Q

Illustration 6 Two capacitors of capacitance C 6 0 09 F and C 3 0...

Physics
Q

Rewrite sin 73.3 in terms of its cofunction.sin 73.3 =(Type an exact answer. Simplify your...

Basic Math
Q

Using the data given below, determine whether it would unusual for a household to have...

Basic Math
Q

Find the equation of the line tangent to the graph of f(x) = (In x)^4...

Calculus
Q

Indicate whether each of the following costs would be classified as direct materials, direct labor,...

Accounting
Q

Imperial Jewelers manufactures and sells a gold bracelet for $409.00. The companys accounting system says...

Accounting
Q

Sunshade produces a special canvas top for its high quality aluminum gazebo. The costs to...

Accounting