The department of commerce for a country released the data below for the quarter
ID: 3260936 • Letter: T
Question
The department of commerce for a country released the data below for the quarterly retail e-commerce sales in millions of dollars for 2008 and 2009. Complete parts a through d. Year 2008 2009
Quarter 1 2 3 4 1 2 3 4
Sales 1925 2638 3499 3976 4061 4606 5315 5876
I am trying to put this into a regression analysis in excel. However I seem to be choosing the wrong input range as the answers like the test statistic I am getting are not right. Would someone please clarify what the x and y ranges I should be using thank you.
Explanation / Answer
Here the Quarters i.e. Q1, Q2, Q3, and Q4 are the x-values. Sales values are donted in y. Like for year 2008 sales values for Quarter 1,2,3 and 4 are 1925, 2638,3499,3976 respectively. Similarly we can do regression analysis for the year 2009 putting Quarters in x and Sales values in y. So x-range should be 1 to 4. y-range can be put as say 1000 to 10000.