A small convenience store chain is interested in modeling the weekly sales of a store as...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A small convenience store chain is interested in modeling the weekly sales of a store as a function of the weekly traffic flow on the street where the store is located. The table below contains data collected from 25 stores in the chain. The convenience store chain is interested in predicting weekly sales based on weekly traffic flow. Store Weekly Traffic Flow (thousands of cars) 59.3 60.3 Weekly Sales (S thousands) 6.3 6.6 3. 82.1 7.6 4 32.3 98.0 3.0 5. 9.5 6. 54.1 5.9 7 54.4 6.1 8 51.3 36.7 5.0 9. 3.6 10 23.6 2.8 11 57.6 6.7 12 44.6 75.8 5.2 8.2 13 14 48.3 3.9 5.4 15 41.4 16 52.5 41.0 4.1 3.1 17 18 29.6 19 49.5 5.4 20 73.1 8.4 6.8 67.5 64.5 21 22 6.7 23 50.3 4.9 24 21.5 2.5 25 69.0 6.9 1) [1 mark] Identify the independent variable (x) and the dependent variable (y). Include the units. HINT: Which variable is the one we want to predict? Is "the variable we want to predict" the independent or the dependent variable? One of the posted Example Videos will help. 2) [2 marks] Create an appropriate scatterplot using Excel. Label axes appropriately, and a provide an overall title. Save your scatterplot as an image and insert it into your Word file with your assignment answers. Do not submit your Excel file. Hand-drawn graphs will receive a grade of 0. Note ExampleVideo5, the video walkthrough of Example 7 from the Module 5 required reading, will help. 3) [7 marks] State the fitted regression equation. Do not use Excel, except to check your answer (do not submit any Excel content). Show: 1) the equation you use 2) how you plug in, and 3) your final answer, for each equation used. Round the sample covariance to 2 decimal places, and the fitted slope to 2 decimal places. Do not round any other values until you reach your final answer, then round each fitted coefficient to 2 decimal places. HINT: You are strongly encouraged to copy/paste from the Tutorial 5 Solutions document and modify the equations as necessary to save time. 4) [2 marks] Using your fitted regression line from question 3, calculate the residual for the first observation. Show 1) the equation you use, 2) how you plug in, and 3) your final answer, rounded to the nearest 2 decimal places. Explain what this value means, in this context, in one sentence. A small convenience store chain is interested in modeling the weekly sales of a store as a function of the weekly traffic flow on the street where the store is located. The table below contains data collected from 25 stores in the chain. The convenience store chain is interested in predicting weekly sales based on weekly traffic flow. Store Weekly Traffic Flow (thousands of cars) 59.3 60.3 Weekly Sales (S thousands) 6.3 6.6 3. 82.1 7.6 4 32.3 98.0 3.0 5. 9.5 6. 54.1 5.9 7 54.4 6.1 8 51.3 36.7 5.0 9. 3.6 10 23.6 2.8 11 57.6 6.7 12 44.6 75.8 5.2 8.2 13 14 48.3 3.9 5.4 15 41.4 16 52.5 41.0 4.1 3.1 17 18 29.6 19 49.5 5.4 20 73.1 8.4 6.8 67.5 64.5 21 22 6.7 23 50.3 4.9 24 21.5 2.5 25 69.0 6.9 1) [1 mark] Identify the independent variable (x) and the dependent variable (y). Include the units. HINT: Which variable is the one we want to predict? Is "the variable we want to predict" the independent or the dependent variable? One of the posted Example Videos will help. 2) [2 marks] Create an appropriate scatterplot using Excel. Label axes appropriately, and a provide an overall title. Save your scatterplot as an image and insert it into your Word file with your assignment answers. Do not submit your Excel file. Hand-drawn graphs will receive a grade of 0. Note ExampleVideo5, the video walkthrough of Example 7 from the Module 5 required reading, will help. 3) [7 marks] State the fitted regression equation. Do not use Excel, except to check your answer (do not submit any Excel content). Show: 1) the equation you use 2) how you plug in, and 3) your final answer, for each equation used. Round the sample covariance to 2 decimal places, and the fitted slope to 2 decimal places. Do not round any other values until you reach your final answer, then round each fitted coefficient to 2 decimal places. HINT: You are strongly encouraged to copy/paste from the Tutorial 5 Solutions document and modify the equations as necessary to save time. 4) [2 marks] Using your fitted regression line from question 3, calculate the residual for the first observation. Show 1) the equation you use, 2) how you plug in, and 3) your final answer, rounded to the nearest 2 decimal places. Explain what this value means, in this context, in one sentence.
Expert Answer:
Answer rating: 100% (QA)
The response variable is y Weekly sales and the independent v... View the full answer
Posted Date:
Students also viewed these accounting questions
-
A hotel chain is interested in evaluating reservation processes. Guests can reserve a room by using either a telephone system or an online system that is accessed through the hotels web site....
-
A major department store chain is interested in estimating the mean amount its credit card customers spent on their first visit to the chain's new store in the mall. Fifteen credit card accounts were...
-
A major department store chain is interested in estimating the mean amount its credit card customers spent on their first visit to the chain's new store in the mall. Fifteen credit card accounts were...
-
Solve the equation symbolically. Then solve the related inequality. - - x] S | - H =
-
Example 5.15 described a study that involved substituting sunflower meal for a portion of the usual diet of farm-raised sea breams (Aquaculture [2007]: 528534). This paper also gave data on y = feed...
-
Weyerhaeuser, the forest products producer, traded at $42 at the beginning of 1996. Beta services typically place its beta at 1.0 with a market risk premium of 6 percent. The risk free rate at the...
-
Could a contract be difficult to categorize as either public or private international law? What would such a contract look like?
-
a. What are the arrival rate of 911 calls and the service rates for each precinct? b. Does the arrival rate of calls for each precinct appear to follow a Poisson distribution? c. Does the service...
-
ing the Question 2 Solve the following problem with branch and bound algorithm: max z = 3x1 + x2 st: 2x1 - x2 6 x1 + x2 4 x1, x2 0, xinteger
-
Go to the Webinars worksheet. DeShawn wants to determine the number of webinars the company can hold on Tuesdays and Thursdays to make the highest weekly profit without interfering with...
-
Convert the following concentrations: 100 ppmv (parts-per-million (a) mol/L (b) mg/m 10C on volume basis) NH3 in air at 1 atm and 20C as:
-
Show how priority inheritance can cause a deadlock. Consider three tasks (with 1 > 2 > 3 ) and appropriate lock unlock sequences.
-
A software module is to take as inputs four signed 16 - bit integers and produce two outputs, the sum and average. How many test cases would be needed for an exhaustive testing scheme? How many would...
-
The United Nations Conference on Trade and Development (UNCTAD) provides ranking of the largest transnational corporations (TNCs) in the world, including a ranking of the 100 largest financial TNCs...
-
Do the same as Exercise 8.3, except recalculate now the FP+ (feature point) metric. How many lines of C ++ code do you estimate will be needed? Data from Exercises 8.3 Recalculate the FP (function...
-
Answer true or false to the following statements: a. Microsoft's SourceSafe is an example of a software-based librarian. b. In a typical IT shop, analysts spend at most about 20 percent of their time...
-
There are several different terms used to describe the Holocaust, which term is officially recognized by the Knesset in Israel? There are several different terms used to describe the Holocaust, which...
-
The diameter of a sphere is 18 in. Find the largest volume of regular pyramid of altitude 15 in. that can be cut from the sphere if the pyramid is (a) square, (b) pentagonal, (c) hexagonal, and (d)...
-
Summer and winter constellations are different because (a) of the spin of Earth about its polar axis. (b) the night sky faces in opposite directions in summer and winter. (c) of the tilt of Earths...
-
The longest-lived stars are those of (a) low mass. (b) high mass. (c) intermediate mass. (d) infinite mass.
-
What is the star nearest Earth? (a) Proxima Centauri (b) Polaris (c) Mercury (d) the Sun
Study smarter with the SolutionInn App