Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

image text in transcribedimage text in transcribedimage text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Precalculus With Limits

Authors: Ron Larson

3rd Edition

1285607163, 9781285607160

More Books

Students also viewed these Mathematics questions

Question

Summarize the forms and functions of nonverbal communication.

Answered: 1 week ago

Question

1. To generate a discussion on the concept of roles

Answered: 1 week ago

Question

6. What information processes operate in communication situations?

Answered: 1 week ago