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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Prove that step by step and clear handwritten. Follow the comment Conception: Limit point 1.Prove N'=empty 2.Prove Q'=R 3. E=(2,5),...

Advance Math
Q

Calculate the pH after 0.16 mole of NaOH is added to 1.10 L of a solution...

Chemistry
Q

List four key characteristics of the adaptive immune response

Medical Sciences
Q

Q12. A local property manager only deals with landlords and tenants in the residential and commercial sector....

Civil Engineering
Q

How is the income/retirement plan of wealthy individuals related to their gender and their race/ethnicity?

Psychology
Q

Question 4 Based on the graph what are the optimal temperatures for the human enzyme...

Biology
Q

Five elements A B C D and E have work functions 1 2 eV 24eV...

Physics
Q

two charges The electric field due to a discrete charge configuration is not defined at...

Physics
Q

Pharoah Company uses a periodic inventory system. For October, when the company sold 730 units,...

Accounting
Q

darden company has cash of $31,000, accounts receivable of $41,000, inventory of $21,500, and equipment...

Accounting
Q

What is the definition of inventory under IFRS? The text gives several examples of assets...

Accounting
Q

|,| The contribution margin income statement of Krazy Cream Donuts for August 2024 follows: (Click...

Accounting