[go: up one dir, main page]
Scribd
Upload
18 views4 pages

Regression

The document presents a detailed analysis of marketing spend and sales data over a 12-month period, including calculations for predicted sales, errors, and goodness of fit metrics. It summarizes the relationship between marketing expenditure and sales performance, highlighting key statistics such as total marketing spend of $78 million and total sales of $900 million. The analysis indicates a strong correlation with an adjusted R-squared value of approximately 0.997.

Uploaded by

207025swastika
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
18 views4 pages

Regression

The document presents a detailed analysis of marketing spend and sales data over a 12-month period, including calculations for predicted sales, errors, and goodness of fit metrics. It summarizes the relationship between marketing expenditure and sales performance, highlighting key statistics such as total marketing spend of $78 million and total sales of $900 million. The analysis indicates a strong correlation with an adjusted R-squared value of approximately 0.997.

Uploaded by

207025swastika
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Month Marketing Spend $ million Sales $ million K Q k*Q k^2

1 2.00 22.00 (4.50) (53.00) 238.5 20.25


2 4.00 45.00 (2.50) (30.00) 75 6.25
3 5.00 60.00 (1.50) (15.00) 22.5 2.25
4 4.00 48.00 (2.50) (27.00) 67.5 6.25
5 3.00 36.00 (3.50) (39.00) 136.5 12.25
6 4.00 45.00 (2.50) (30.00) 75 6.25
7 9.00 102.00 2.50 27.00 67.5 6.25
8 10.00 120.00 3.50 45.00 157.5 12.25
9 15.00 168.00 8.50 93.00 790.5 72.25
10 12.00 140.00 5.50 65.00 357.5 30.25
11 7.00 78.00 0.50 3.00 1.5 0.25
12 3.00 36.00 (3.50) (39.00) 136.5 12.25
SUM 78.00 900.00 2126 187
6.50 75.00

B1 Predicted 11.368984
B0 1.10
RSS TSS ESS
Predicted Sales Error Squared ErrorSquare of s.d of sales
23.84 (1.84) 3.38 2809 2,617.39
46.58 (1.58) 2.49 900 807.84
57.95 2.05 4.22 225 290.82
46.58 1.42 2.02 729 807.84
35.21 0.79 0.63 1521 1,583.36
46.58 (1.58) 2.49 900 807.84
103.42 (1.42) 2.02 729 807.84
114.79 5.21 27.13 2025 1,583.36
171.64 (3.64) 13.22 8649 9,338.59
137.53 2.47 6.10 4225 3,909.93
80.68 (2.68) 7.21 9 32.31
35.21 0.79 0.63 1521 1,583.36
71.54 24242 24170.45989 Sum
Avg
B1 Predicted
Goodness of Fit 0.997048919 B0
Goodness of Fit
Adjusted R squared 0.996753811 Adjusted R Squared
K Q
Marketing Spend $ million Sales $ million K Q K*Q k^2 Predicted Sales
2.00 22.00 (4.50) (53.00) 238.5 20.25 23.84
4.00 45.00 (2.50) (30.00) 75 6.25 46.58
5.00 60.00 (1.50) (15.00) 22.5 2.25 57.95
4.00 48.00 (2.50) (27.00) 67.5 6.25 46.58
3.00 36.00 (3.50) (39.00) 136.5 12.25 35.21
4.00 45.00 (2.50) (30.00) 75 6.25 46.58
9.00 102.00 2.50 27.00 67.5 6.25 103.42
10.00 120.00 3.50 45.00 157.5 12.25 114.79
15.00 168.00 8.50 93.00 790.5 72.25 171.64
12.00 140.00 5.50 65.00 357.5 30.25 137.53
7.00 78.00 0.50 3.00 1.5 0.25 80.68
3.00 36.00 (3.50) (39.00) 136.5 12.25 35.21
78.00 900.00 2,126.00 187.00
6.50 75.00
11.3689839572193
1.10
0.997048918944317
0.996753810838749
RSS TSS ESS
Error Squared Error Square of s.d of sales
(1.84) 3.384025851 2809 2,617.39
(1.58) 2.488632789 900 807.84
2.05 4.216763419 225 290.82
1.42 2.023392147 729 807.84
0.79 0.626383368 1521 1,583.36
(1.58) 2.488632789 900 807.84
(1.42) 2.023392147 729 807.84
5.21 27.12905716 2025 1,583.36
(3.64) 13.2231405 8649 9,338.59
2.47 6.103806228 4225 3,909.93
(2.68) 7.206497183 9 32.31
0.79 0.626383368 1521 1,583.36
71.54 24,242.00 24,170.46

You might also like