wk7.v2.pdf - You can access the new Success Center via the...

This preview shows page 1 - 4 out of 26 pages.

0.0/ 1.0 Points0.0/ 1.0 PointsWeek 7 Knowledge Check Homework Practice QuestionsReturn to Assessment ListPart 1 of 9 - Linear Regression and Correlation0.0/ 2.0 PointsQuestion 1 of 20Which of the following equations are linear?A. 4y=8B. y2=6x3+8C. 3y=6x+5y2D. y-x=8x2Answer Key: Feedback:A linear equation is a linear line. If a problem has a squared or a cubed term, it isn't linear. It is a quadraticequation.
A
Question 2 of 20A vacation resort rents SCUBA equipment to certified divers. The resort charges an up-front fee of$25 and another fee of $12.50 an hour. What is the dependent variable?A. timeMATH302 I008 Win 20Tests & QuizzesTests & QuizzesYou can access the new Success Center via the left hand navigation in your classrooms. This tool is updatedregularly and provides access to hundreds of relevant resources geared towards your academic and professionalgoals. Check it out!
1.0/ 1.0 Points
D
Part 2 of 9 - Multiple Linear Regression1.0/ 4.0 PointsQuestion 3 of 20You are thinking about opening up a Starbucks in your area but what to know if it is a goodinvestment. How much money do Starbucks actually make in a year? You collect data to, to help estimate AnnualNet Sales, in thousands, of dollars to know how much money you will be making.You collect data on 27 stores to help make your decision.x1 = Rent in Thousand per monthx2 = Amount spent on Inventory in Thousand per monthx3 = Amount spent on Advertising in Thousand per monthx4 = Sales in Thousand per monthx5= How many Competitors stores are in the AreaApproximately what percentage of the variation in Annual Net Sales is accounted for by these 5 variables in thismodel?See Attached Excel for Data.Starbuck Sales data.xlsx9 KB
Answer Key: BFeedback:The R-squared value is the amount of explained variance in the data points in the model. You convert this decimalto a percent.You can run a Multiple Linear Regression in Excel using the Data Analysis ToolPak.Data -> Data Analysis -> Scroll to RegressionHighlight Annual Net Sales for the Y Input:Highlight all 5 columns from Rent to Competitor for the X Input:Make sure you click on Labels and Click OKIf done correctly thenR Square0.982353754Adjusted R Square0.978152267R-squared:98.24% of variation in the Annual Net Sales is accounted for by Rent, Inventory, Advertising, Sales per Month and# of Competitor store in this model.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture