Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please find table and question attached 1. Place the quantity (Y,), price (P,) and advertising (R.) data from Table 1 in a Microsoft Excel spread

please find table and question attached

image text in transcribedimage text in transcribed
1. Place the quantity (Y,), price (P,) and advertising (R.) data from Table 1 in a Microsoft Excel spread sheet and calculate the following values: EYE; Y; Exit ; Xji EX2.ti X2 t= 1 2 Manually calculate the following values in deviation form: a. Sum values b. Standard deviations 3 Manually calculate the Bi, B2 and a-coefficient values. 4 Prepare a correlation matrix for the variables: quantity, price, and advertising expenditures. 5 In a Spreadsheet, manually calculate the following values: The total sum of the square's SST. The standard error of the estimated regression equation S. poop Calculate the standard error of the estimated coefficients Bi en B2. The Durbin-Watson-statistic: DW. 6 Further manually calculate the following values: a. Sum of the squares due to regression SSR b . The determination coefficient R5. C. The adjusted multiple determination coefficients R.5. 7 po Calculate the t-values of the estimated Bi- and B2-coefficients. b. Are these significant at the 5 %-level? Is autocorrelation present in the residuals? Calculate the MPE- and MAPE-values for your estimated model. 10 Present your estimated model in a formal way with the associated accuracy measurements.Product C: Quantity, Price, Advertising, and Rival Price Quantity Price Advertising Rival (x 1 000) (x 1 000) price t Y Pt PF 2019 5.399 12.75 10.250 12.75 2 5.408 12.75 10.250 12.75 3 5.323 11.75 10.000 11.50 4 5.340 11.75 10.100 11.50 U 5.520 11.50 10.400 11.25 6 5.487 11.88 10.270 1175 5.509 12.38 10.400 1213 8 5.559 11.75 10.750 11.50 9 5.450 11.75 10.270 11.50 10 5.454 10.88 10.270 10.38 11 5.467 10.38 10.270 9.38 12 5.527 10.00 10.400 9.00 2020 5.587 10.00 10.800 8.25 2 5.620 9.75 10.820 8.50 3 5.569 9.75 10.750 8.50 5.666 9.75 10.820 9.50 5.733 10.00 11.100 10.50 JOU 5.714 10.00 11.000 10.50 5.736 10.25 11.100 10.50 8 5.812 10.00 11.750 10.13 9 5.742 9.50 11.100 9.75 10 5.742 9.00 11.100 9.50 11 5.776 8.75 11.500 9.75 12 5.725 8.75 11.000 10.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

An Introduction to the Mathematics of financial Derivatives

Authors: Salih N. Neftci

2nd Edition

978-0125153928, 9780080478647, 125153929, 978-0123846822

More Books

Students also viewed these Mathematics questions