Summarize your results from Steps 1-11 in a report. The report should explain and interpret the results in ways that are understandable to someone who does not know statistics.

Step 1 scatterplot: For the dependent variable I used (Y "Sales") and the selected independent variable I chose (X2 "Time").

Step 2 : Determine the equation of the "best fit" linebetween the independent X (time) and dependent Y (sale ) variables

y = 48.25421757 - 0.219344686 * x

Step 3 Determine the correlation coefficient. Interpret

r^2= - 0.133987857

This correlation coefficient is very close to 0, therefore we can conclude that there is a weak negative relationship between the two variables.

Step 4.Determine the coefficient of determination. Interpret.

coefficient of determination = 0.017952746 or 1.795%

which indicates that 1.795% of the variation in sales can be described or explained by the time and

Step 5Test the utility of this regression model by completing a hypothesis test of b=0 using =0.10. Interpret results, including the p-value.

The T test for the slope is given in the regression output as:-1.3385

The P value for a 2 sample alternative at a of 98 level is 0.1838

since the P value is greater than the significance level of 0.10, we can conclude that we will fail to reject the null hypothesis and that the slope = 0

Step 6Based on the findings in steps 1-5, analyze the ability of the independent variable to predict the dependent variable.

Based off the variables I chose there is not a good enough to predict the dependent variable there is not a very good correlation.

Step 7 Compute the confidence interval for b, using a 95% confidence level. Interpret this interval.

At the 95% confidence interval the slope that was found is given in the regression output as ( -0.544550882 to 0.105861509 )

My interpretation is we can be 95% confident that the actual value of the slope of regression between time and sales is between -0.54455 and 0.10586

Step 8Compute the 99% confidence interval for the dependent variable, for a selected value of the independent variable. Each student can choose a value to use for the independent variable (use same value in the next step). Interpret this interval.

The 99% confidence interval for the sales when the time =14

Error= 0.0619

T value 99% confidence interval with a degree of 98 = 2.6269

Margin of error =0.1626

45.18340.1626= (45.0208,45.346)

Confidence interval =45.0208

we can be 99% confident that the actual number of sales when time is =14 is between 45.0208 and 45.346

Step 9Using the same chosen value for part (8), estimate the 99% prediction interval for the dependent variable. Interpret this interval.

Error=0.5748

T value for 99% confidence interval at a 98 degree= 2.6269

Margin of error = 1.5099

45.18341.5099= (43.6735,46.6933)

Prediction interval =43.6735<y<46.6933

My interpretation is that we are 99% sure that the next prediction sales for a time of 14 will be within this interval.

Step 10 What can be said about the value of the dependent variable for values of the independent variable that are outside the range of the sample values? Explain.

This relationship is not very strong. We shouldn't use the time variable to predict the value of the dependent variables for independent variable values which are also outside the sample values.

Step 11 Describe a business decision that could be made based on the results of this analysis. In other words, how might the business operations change based on these statistical results.

Based off the analysis I can conclude that because time doesn't affect sales that weather we increase or decrease the time it would not have a direct effect on the sales.

DATA

SalesCalls Time. Years Type

4413915.32GROUP

3811715.33NONE

4314814.54ONLINE

4512013.61GROUP

3714015.73GROUP

4414813.53GROUP

4615116.01GROUP

4918416.72ONLINE

4213514.83NONE

4917714.22GROUP

4817513.71ONLINE

4915222.31ONLINE

4916111.73NONE

3814517.1.2NONE

441698.90ONLINE

4418812.93GROUP

4111715.82GROUP

4215414.82ONLINE

4216717.73ONLINE

4011715.61NONE

4712016.31NONE

3713315.22GROUP

4614516.80ONLINE

5016716.21ONLINE

4813613.73ONLINE

4216718.02NONE

4615314.11ONLINE

4817418.62GROUP

4214810.01NONE

4215315.52GROUP

5718010.82NONE

4315315.23GROUP

4616216.22ONLINE

5618013.52ONLINE

4114014.71GROUP

4715714.31GROUP

3712018.22GROUP

3714816.21GROUP

3915613.34NONE

4817713.93ONLINE

5317813.22ONLINE

4916013.63GROUP

4515518.92GROUP

4617212.51ONLINE

5217714.51ONLINE

4314518.62NONE

4916616.20ONLINE

3714514.03NONE

4815615.14ONLINE

3715219.80GROUP

4216010.63NONE

3711714.80GROUP

4914921.12GROUP

4416913.61ONLINE

5016712.65ONLINE

5019011.31ONLINE

5819711.81ONLINE

4115013.63GROUP

4313116.84GROUP

4718312.82ONLINE

4314815.91ONLINE

5017711.44NONE

5019714.02ONLINE

4717614.12ONLINE

5018410.82ONLINE

4015010.81GROUP

4418215.54NONE

4513819.34GROUP

4816519.85ONLINE

4516416.73NONE

4316613.33ONLINE

4514612.03GROUP

4317319.82ONLINE

4115710.03ONLINE

4515813.91ONLINE

5318210.51ONLINE

5318415.25ONLINE

4115819.32ONLINE

4517317.62ONLINE

4918820.41NONE

3914918.81GROUP

4616212.11GROUP

4014417.40NONE

3913815.51NONE

4513813.61GROUP

4518513.31ONLINE

4415018.41NONE

3413314.41GROUP

4614917.83NONE

4614813.11GROUP

4316913.34NONE

4817113.02GROUP

5117318.60ONLINE

5818912.01ONLINE

3714217.12NONE

4417113.63GROUP

4715515.30ONLINE

5418011.84GROUP

3713716.32GROUP

4415918.12ONLINE