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

Civil Engineering
1.2K views

Under what circumstances might an owner decide to use wrap-up (owner controlled insurance program) insurance. What...

Biology
1.2K views

Listen What is the definition for medial Toward or at the front of the body...

Geometry
1.2K views

Alfred is practicing typing. The first time he tested himself, he could type 45 words...

Basic Math
1.2K views

Find the reference angle for radians wwwww 8 5 0 0

Calculus
1.2K views

4 The graph of a function g is shown on the ay plane on the...

Calculus
1.2K views

The graph of function f x is shown below At which value of x is...

Accounting
1.2K views

! Required information [The following information applies to the questions displayed below.] ...

Accounting
1.2K views

On January 1, 2017, Culver Corporation purchased 30% of the common shares of Larkspur Company...

Accounting
1.2K views

Wolery Incorporated has provided the following data concerning one of the products in its standard...

Accounting
1.2K views

Account Name Type of Account Debit or Cre Liability Credit

Accounting
1.2K views

Amit purchased two assets during the current year. On April 16th Amit placed in service...

Finance
1.2K views

Company A has Sales of $1,000,000; COGS of $350,000; Cash of $100,000; Total Debt of...