Question: Calculate the Y-sales approximate using the constants you obtained from the regression analysis (use month 6 and fill in the first 4 columns, then install

Calculate the Y-sales approximate using the constants you obtained from the regression analysis (use month 6 and fill in the first 4 columns, then install the correct values for "a" and "b" in the last two columns. Finally, use the formula under the "Y-sales Approximation" to calculate the value you regression equation gives you for the new Sales value. Finally, calculate the difference. Month Y - Sales Actual X - Advertising Actual Y - Sales Approximate Y-difference a b 6 15 1.3 17.4339167169584 -2.433916717 0.997586 12.64333 (From table above) (from table above) (from table above) Use the formula below: Use: from from =G28 +H28*D28 =C28-E28 Reg. Anal Reg Anal

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

A company manufacturers a product in the United States and sells it in England. The unit cost of manufacturing is $50. The current exchange rate (dollars per pound) is 1.51. The demand function,...

Forecasting using Simple Linear Regression: For this forecasting we will use historical data for Pizza sales versus Advertizing dollar spent. Instead of hand calculating the regression equation, we...

good afternoon, here is an assignment from pennfoster college which I am unable to do. Can you do it for me? Part 1: El Cap Climbing Company El Cap Climbing Company (ECCC) is a small startup that...

It's painful... Part 1: El Cap Climbing Company El Cap Climbing Company (ECCC) is a small startup that manufactures and sells high-quality climbing gear in Fresno, California. The founder of the...

2015 2016 Cost of Goods Sold 235,942 297,915 Cash 36,542 51,940 Depreciation 61,056 69,011 Interest Expense 13,877 15,905 Selling and Admin Exp 40,952 58,569 Accounts Payable 32,194 33,999 Net Fixed...

FIN310 Graded Project: Corporate Finance Your project must be submitted as an Excel document. Your project will be individually graded by your instructor and, therefore, will take up to a few weeks...

Part 1: El Cap Climbing Company El Cap Climbing Company (ECCC) is a small startup that manufactures and sells high-quality climbing gear in Fresno, California. The founder of the company, Leah, has...

Exercises Chapter 2 2.1 Marginal and conditional probability: The social mobility data from Section 2.5 gives a joint probability distribution on (Y1 , Y2 )= (father's occupation, son's occupation)....

ID Salary 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 59.3 26.5 34.1 56.3 46.8 79.5 41.2 23.6 76 22.7 23.8 62.9 41.4 22.3 23.1 46.6 67.6 33.8 24 35 75.2 51.5 22.1 55.4 24.9 24.3 42.9 76.6 75.4...

7. The purpose of this question is to familiarise you with the use of regression analysis to calculate the parameters of the market model and to interpret these parameter estimates and selected...

ID Salary Compa- Midpoint ratio Age Performance Service Gender Rating Raise Degree Gender Grade 1 Copy Employee Data set to this page. The ongoing question that the weekly assignments will focus on...

If you promise to leave $30,000 on deposit at the Dime Savings Bank for four years, the bank will give you a new large, flat-screen Sony TV today and your $30,000 back at the end of four years. How...

The WEP packet format is shown in Fig. 8-31. Suppose that the checksum is 32 bits, computed by XORing all the 32-bit words in the payload together. Also suppose that the problems with RC4 are...

Every 1 0 years, all seats in the U . S . House of Representatives ( and legislative bodies in statehouses nationwide ) undergo a process called by which some states or regions get more seats and...

2 Analytical Thinking (Algo) [LO5-2, L05-3, L05-4] 25 points Skipped 3 "I think we goofed when we hired that new assistant controller." said Ruth Scarpino, president of Provost Industries. "Just look...