Scribd
Upload
41 views15 pages

Regression Analysis Assignment

The document presents a regression analysis comparing study hours to test scores and advertising spend to sales, indicating a strong correlation with high R-squared values. It includes regression statistics, ANOVA results, and coefficients for the variables analyzed. The analysis suggests that both study hours and advertising spend significantly impact the respective dependent variables.

Uploaded by

damianroi37
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
41 views15 pages

Regression Analysis Assignment

The document presents a regression analysis comparing study hours to test scores and advertising spend to sales, indicating a strong correlation with high R-squared values. It includes regression statistics, ANOVA results, and coefficients for the variables analyzed. The analysis suggests that both study hours and advertising spend significantly impact the respective dependent variables.

Uploaded by

damianroi37
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

Study Hours Test Scores

Independent Dependent
Variable (X) Variable (Y)
5 90 Learning will help me graduate
4 80
100
3 70
90
2 60
80
1 50
70
60
50
40
30
20
10
0
0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5
duate

4 4.5 5 5.5
Advertising Spend Sales
1,000.00 10,000.00 Assignment: Create Regression Analysis using Data Analysis Toolpak
2,000.00 15,000.00
3,000.00 18,000.00
4,000.00 22,000.00
5,000.00 28,000.00
6,000.00 32,000.00
7,000.00 35,000.00
Analysis Toolpak
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.996942265
R Square 0.9938938798
Adjusted R Squa 0.9926726558
Standard Error 788.30740922
Observations 7

ANOVA
df SS MS F Significance F
Regression 1.00 505750000.00 505750000.00 813.85 0.00
Residual 5.00 3107142.86 621428.57
Total 6.00 508857142.86

Coefficients Standard Error t Stat P-value Lower 95%


Intercept 5857.1428571 666.24136093 8.7913227857 0.0003159628 4144.5149165739
X Variable 1 4.25 0.1489760972 28.528066438 9.9138343E-07 3.8670447504722
Upper 95% Lower 95.0% Upper 95.0%
7569.77079771177 4144.51491657395 7569.77079771177
4.63295524952776 3.86704475047224 4.63295524952776
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.996942265
R Square 0.99389388
Adjusted R Square 0.992672656
Standard Error 788.3074092
Observations 7

ANOVA
df SS MS F Significance F
Regression 1.00 505,750,000.00 505,750,000.00 813.85 0.00
Residual 5.00 3,107,142.86 621,428.57
Total 6.00 508,857,142.86

Coefficients Standard Error t Stat P-value Lower 95%


Intercept 5,857.14 666.24 8.79 0.00 4,144.51
X Variable 1 4.25 0.15 28.53 0.00 3.87

How to interpret Regression Analysis Result?


Further Reading:
[Link]
nificance F

Upper 95% Lower 95.0% Upper 95.0%


7,569.77 4,144.51 7,569.77
4.63 3.87 4.63

You might also like