Good afternoon, I am having difficulties running the regression…
Question Answered step-by-step Good afternoon, I am having difficulties running the regression… Good afternoon, I am having difficulties running the regression statistics report from the below. I used the deseasonalized sales figures against the period time which (the column titled “Observation”) for the regression. However my numbers are different from the textbook example. Please see the excel report and Textbook example in the below and let me know what variables I need to use against the period time to get the same exact regression statistics that is reference in the textbook.Image transcription textEstimating Sales with Systematic Variations: Adjusting for Trends and Seasonality A closeexamination of the sales data in Table 15.1 shows us that several strong patterns emerge thatwould be evident even if we were just looking at the 2010 and 2011 monthly sales… Show more… Show moreImage transcription textSTIMATION OF FUTURE SALES BY ADJUSTING FOR SEASONALITY AND TREND singTarget Corporation’s historic monthly sales figures for 2010 and 2011 (see Table 15.1) tocompute monthly seasonal and trend adjustments, estimate the monthly sales fig… Show more… Show moreImage transcription text. The July 2010 actual sales figure, $4,585, is then divided by this 2-CMA to get a seasonalindex for the month of July of approximately 0.8369, meaning that this month’s actual salesfigures are 83.69 percent of the average sales figure for the year exactly surroun… Show more… Show moreImage transcription textNow that we have the deseasonalized sales figures, we can regress them against the timeperiod (the column titled “Observation”) to get parameters for estimating thehistoric trend. The results of this regression are shown in the tables below, with t… Show more… Show moreImage transcription textSales – Actual Deseas, Date Observation Month 2010 & 2011 12-cma 2-CMA Seas-IrregSeas Index Average Seasonal Index Adj. Seas, Index Sales January 00 – – – . . . . . . .- – – – – – 11289.00 0.78678225 0.787276005 $5,447.90 – -L- January 00 wiNi 1637.00 0.84… Show more… Show moreImage transcription textSUMMARY OUTPUT Regression Statistics Multiple R 0.199225505 R Square 0.039690802Adjusted R Square -0.003959616 Standard Error 188.7171852 Observations 24 ANOVA df SSMS F Significance F Regression 32383.54341 32383.54341 0.909288015 0.350… Show more… Show moreMany thanks in advance Math Statistics and Probability ACCOUNTING financial Share QuestionEmailCopy link Comments (0)
