Project 5

Project 5 - Scott Newmyer QBA 2305 Project 5 Multiple...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Scott Newmyer QBA 2305 – Project 5 – Multiple Regression Analysis – Chapter 14 The following data is from a chain of 50 convenience stores. Each row or record of data contains the following variables: (Y) Annual sales (in thousands of dollars) (X 1 ) Average weekly auto traffic volume (in thousands) (X 2 ) Ease of entry/exit (scale of 1 to 100 - larger the better) (X 3 ) Average yearly household income of area (in thousands of dollars) (X 4 ) Number of competing stores within 1 mile (X 5 ) Y es/N o response if manager had received TQM (Total Quality Management) training (Y = yes, N = no.) You will need to move this column to the right and insert the following function in column F: =IF(G2=”Y”,1,0) . Use MegaStat to produce regression analysis summaries necessary to answer the following questions. (1) Calculate the “correlation matrix” for the variables in the study. a. What appears to be the single best predictor of Sales? _____Traffic _________ b. Is multicollinearity a problem? If so between which variables? _Yes between ease and traffic_________________
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/07/2008 for the course QBA 2305 taught by Professor Hulme during the Spring '08 term at Baylor.

Page1 / 2

Project 5 - Scott Newmyer QBA 2305 Project 5 Multiple...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online