Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please use excel so I can attach the files to word STAT 1112 Online Shopping Several studies have found that the frequency with which shoppers

Please use excel so I can attach the files to word

image text in transcribed
STAT 1112 Online Shopping 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 2 Data file, the data collected by Business School students show the age of 60 respondents and their answer to the question, "how many minutes do you browse online retailers per week?" The students want to find out whether variables the age of respondents (years) and the browsing time (min/week) are linearly related to each other. If they are, then how strongly the browsing dime depends on the age of respondents. Please complete the following tasks using Excel. . Construct a scatter diagram for the age of respondents and the browsing time. Do not forget to label the axis. Does it seem that the variables are linearly correlated? Comeisuon Coofficiant b. Find the coefficient of correlation. Find and interpret the coefficient of determination. c. Find the regression equation and plot the regression line. Interpret the slope of the regression line. Can we interpret the y-intercept? Why? d. students consider a group of 5 typical on-line shoppers. Their ages are 29, 36, 47, 54, and 65 years. Using the regression equation find for each of them the most likely browsing time per week in minutes

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

Discrete Mathematics

Authors: Gary Chartrand, Ping Zhang

1st Edition

1478616261, 9781478616269

More Books

Students also viewed these Mathematics questions

Question

understand the general outline and structure of the current book.

Answered: 1 week ago