Hello, I had a couple of assignments today, this is just one of them. They are not very hard. So please do not ask so much for this assignment. I still have many more please
Unformatted Attachment Preview
MGMT 650 Fall 2017 Week 11 Homework
(Last updated 7/11/2017)
1. Scatterplot and Correlation
Studies have shown that the frequency with which shoppers browse Internet retailers is related to the frequency
and/or services online. These data show the age of respondents and their answer to the question How many mi
Browsing Time (min/wk)
Browsing Time against
a) Calculate the associated correlation coefficient and discuss how strong you think the relationship is between th
Correlation procedures within Excel under Data > Data Analysis.
b) Find the correlation coefficient using the Excel function CORREL.
c) Set up a scatter (xy) diagram with Age on the horizontal axis. Add the chart name and axes descriptions to your
d) Add a trendline to the diagram.
e) Find the equation of the regression line. (Hint: One way to do this is by adding the equation to the trendline. Go
f) Predict the number of minutes spent by a 40-year old shopper.
g) Can you use this data to predict the number of minutes spent by a 75 year old shopper? How about a 35 year o
elated to the frequency with which they actually purchase products
question How many minutes do you browse online retailers per
wsing Time against age
y = -11.503x + 750.02
R² = 0.9679
lationship is between the age and the browsing time. Use the
xes descriptions to your chart.
tion to the trendline. Go to format trendline and find it there).
? How about a 35 year old?
2. Regression and Correlation
An agent would like to predict the monthly rental cost for apartments, based on the size of the apartment, as defi
sample of 25 apartments in a particular residential neighborhood and gathers the data shown in the table.
Size (Square feet)Rent (Dollars)
a) Find the correlation coefficient. Is it strong or weak? Positive or negative?
Run the Regression function from the Data Analysis tools and use the results to answer the following questions:
b) Find the equation of the regression line.
c) Find the slope, and interpret its meaning.
d) Compute the coefficient of determination, R Square, and interpret its meaning.
e) Compute the standard error of estimate, and interpret its meaning.
he size of the apartment, as defined by square footage. The agent selects a
data shown in the table.
nswer the following questions:
Make an XY scatter plot linked to the following data on this sheet.
The scatterplot reveals an outlier. Copy the data to a new sheet or a new area on this sheet, and remove th
Right click on the points, Add Trendline, Display Equation on chart, Display R-Squared value on chart
Read the intercept directly from the chart equation label. The elevation of the line above the origin with
Read the slope directly from the chart equation label. The slope of the line with 3 decimal places =
So, when X increases by 1, the change in Y =
directly from the chart equation label. The amount of the variation in Y explained by X in percen
a on this sheet, and remove the outlier. You should now have 24 rows of data above. Make a new scatterplot from the revised data.
-Squared value on chart
he line above the origin with 3 decimal places =
with 3 decimal places =
in Y explained by X in percent is =
Highlight the correct answer or answers for each of the following questions
The best fitting line is found using advanced math to minimize the vertical distances from the points to the li
Hence, the Y coordinate of a point on the best fitting line provides an estimate of Y at the value of the corres
This process is called regression (to move backward) because
? The estimate of Y will be closer to the mean in standard deviations than X is.
? The estimate of Y will be farther from the mean in standard deviations than X is.
Highlight all assumptions requiring validation for linear regression and prediction
? Scatter plot pattern is reasonably straight (Linearity)
? No points lie far enough away to pull the line of best fit away from the main point pattern.
? The plot does not fan out as x increases or decreases (Equal Spread)
? Predict Y at a value of X within the range of the X data
The “intercept” and “slope” completely define the best fitting line.
The intercept is the vertical distance from the origin (where the X and Y axes intersect) up to the line. It sets
As the slope increases
? The line moves up
? The line moves down
? The line rotates clockwise
? The line rotates counterclockwise
R2 measures the fit of the line to the points. As R2 increases
? The scatter about the line increases and the amount of the variation of Y explained by X decreases
? The scatter about the line decreases and the amount of the variation of Y explained by X increases
? The scatter about the line increases and the amount of the variation of Y explained by X increases
? The scatter about the line decreases and the amount of the variation of Y explained by X decreases
The correlation R measures the linear dependence of Y on X, and does not have a unit of measure.
Highlight the 3 correct statements
? X denotes the independent or response variable
? X denotes the independent or explanatory variable
? Y denotes the dependent or explanatory variable
? Y denotes the dependent or response variable
? x denotes the observed value of the dependent variable
? denotes the mean value of observations of the response variable
tances from the points to the line.
e of Y at the value of the corresponding X coordinate
intersect) up to the line. It sets the elevation of the line
explained by X decreases
xplained by X increases
explained by X increases
xplained by X decreases
ave a unit of measure.
Purchase answer to see full
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more