Using the data below perform data analysis using Regression analysis, run regres
ID: 3223290 • Letter: U
Question
Using the data below
perform data analysis using Regression analysis, run regression with excel,test for fitness- R2 R and fisher
test for significance: state the hypothesis at 5% level of significance
predict sales using moving average 2 or 3 period
test for accuracy using MAD2 MAD3
Compare and draw conclusions
year
Merchandise Cost
X ( millions)
Net Sales
Y (millions)
2002
3,127
37,994
2003
3,339
41,694
2004
3,643
47,148
2005
4,014
51,879
2006
4,568
58,963
2007
4,879
63,087
2008
5,039
70,977
2009
5,405
69,889
2010
5,638
76,255
2011
6,638
87,048
2012
7,096
97,062
2013
7,894
102,870
2014
8,456
110,212
2015
8,908
113,666
2016
8,969
116,073
year
Merchandise Cost
X ( millions)
Net Sales
Y (millions)
2002
3,127
37,994
2003
3,339
41,694
2004
3,643
47,148
2005
4,014
51,879
2006
4,568
58,963
2007
4,879
63,087
2008
5,039
70,977
2009
5,405
69,889
2010
5,638
76,255
2011
6,638
87,048
2012
7,096
97,062
2013
7,894
102,870
2014
8,456
110,212
2015
8,908
113,666
2016
8,969
116,073
Explanation / Answer
MAD = 140,979 / 12 = 11748.25
Compare and Conclusion
Conclusion : MAD for 2nd year is less hence the accuracy is more comapare to moving average 3rd year.
Regression Statistics Multiple R 0.996 R Square 0.993 Adjusted R Square 0.992 Standard Error 2394.274 Observations 15.000Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.