Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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)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}
- Does it seem that the variables are linearly correlated?Interpret the chart?{2}
- 2)Interpretthe coefficient of determinationr2. {2}
- 3)Findandinterpretthe coefficient of correlationr. {2}
- 4)Findandinterprettheslopeof the regression line. {2}
- 5)Using the regression equationfindthe most likely browsing time for a60-year-old person. {2}
- 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}
- (Data ? Data Analysis ? Regression)
data provided in the screenshots there are 100 samples total
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started