Question: please provide excel file or step by step answer thank you Several studies have found that the frequency with which shoppers browse internet retailers is

 please provide excel file or step by step answer thank you

please provide excel file or step by step answer thank you

Several studies have found that the frequency with which shoppers browse internet retailers is related to the frequency with which they actually purchase products and/or services online. In the Assignment 3 Data file, the data show the age of respondents and their answer to the question,"how many minutesdo you browseonline retailers per week?"

Please complete the following tasks usingExcel.

  1. 1)Construct a scatter diagram for theage of respondentsandbrowsing time (min/week)using the first as an independent variablexand the second as a dependent variabley.Findthe regression equation andplotthe regression line. (Do not forget about the label, regression equation, coefficient of determinationr2and axis titles). {5}
  2. Does it seem that the variables are linearly correlated?Interpret the chart?{2}
  3. 2)Interpretthe coefficient of determinationr2. {2}
  4. 3)Findandinterpretthe coefficient of correlationr. {2}
  5. 4)Findandinterprettheslopeof the regression line. {2}
  6. 5)Using the regression equationfindthe most likely browsing time for a60-year-old person. {2}
  7. 6)Does there appear to be a significant linear relationship between theage of respondentsandbrowsing time (min/week)in the population of all online shoppers at5%significance level? {5}
  8. (Data ? Data Analysis ? Regression)

data provided in the screenshots there are 100 samples total

Several studies have found that the frequency with which shoppers browse internetretailers is related to the frequency with which they actually purchase productsand/or services online. In the Assignment 3 Data file, the data show

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!