Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. basic math
  3. i need the correct excel equation for this questio

I need the correct excel equation for this question: A toy company buys large quantities of...

90.2K

Verified Solution

Question

Basic Math

I need the correct excel equation for this question:

A toy company buys large quantities of plastic pellets for usein the manufacturing of its products. The production manager wantsto develop a forecasting system for plastic pellet prices and isconsidering four different approaches and 6 different models. Heplans to use historical data to test the different models foraccuracy. The price per pound of plastic pellets (actual) hasvaried as shown:

Month

Price/Pound

1

$0.39

2

0.41

3

0.45

4

0.44

5

0.40

6

0.41

7

0.38

8

0.36

9

0.35

10

0.38

11

0.39

12

0.43

13

0.37

14

0.38

15

0.36

16

0.39

SIMPLE LINEAR REGRESSION

  • Use all of the data, months 1-16, to calculate the regressionequation for this data. Use the months (1-16) as the independentvariable (x) and price as the dependent variable (y). Once you havethe equation, forecast months 7-16 (enter 7, 8, etc. as the x valuein the equation). Calculate the MAD for this forecasting model.Comment on the goodness of fit (R2) and significance ofthe model (F significance) to determine if this forecast modelshould be included in the consideration of the differentapproaches. (If the model is not significant, it cannot beconsidered, however, you must still make the forecasts andcalculate the MAD).

Answer & Explanation Solved by verified expert
3.7 Ratings (546 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

Finance
1.2K views

Examine the following book-value balance sheet for University Products Inc. The preferred stock currently sells for...

General Management
1.2K views

What are some of the reasons a company might decide to outsource its warehouse functions?

Biology
1.2K views

Persons preparing and signing the Pick up Request Form are required to take the following...

Physics
1.2K views

A rectangular metal loop ABCD is moving in uniform transverse magnetic field B with constant...

Basic Math
1.2K views

Use the even odd and periodic properties of the trigonometric functions to simplify 5 cot...

Algebra
1.2K views

Graph t x 2x 3 on the Cartesian plane to the right t x is...

Algebra
1.2K views

9x 45 x 7x x 10x 25 x2 2x 35

Accounting
1.2K views

At December 31,2025, Concord Corporation estimates that goods with a selling price...

Accounting
1.2K views

A parents beginning inventory contains unconfirmed profits on goods purchased from its subsidiary of $75,000....

Accounting
1.2K views

On September 1, 2016, the Ichabod Crane Equipment, Inc. sold equipment to Bob Builder Corporation...

Accounting
1.2K views

A manufacturer of industrial equipment has a standard costing system based on standard direct labor-hours...

Finance
1.2K views

Sau 7 points You as a bank would like to calculate debt to total assets...