STAT4610 Project 4 Multiple Regression Model and Business Report For this Project you will collect data, perform preliminary data analysis, build and analyze a model, and use the results of your analysis to make predictions, draw conclusions, and support decisions. The Project will be submitted in two phases: Phase I: Collect data and describe your data set. Perform preliminary analysis of your data, using descriptive statistics [0 points, but corrections not made for Phase II will result in a deduction, as will late or missing submissions]. (Due before class, Lesson 13.) Phase II: Build a multiple regression model from your data, and prepare a business report that includes all of your previous work, and that presents a recommendation to a decision-maker based on your model and analysis [250 points]. (Word Doc or pdf due thru CANVAS at the beginning of class, Lesson 15.) PROJECT DETAILS Phase I, Data Collection and Preliminary Data Analysis You may collect your data from (almost) any source(s). The objective is to find a numerical response (dependent) variable that can be predicted from some number of other (independent) variables. (The independent variables may be categorical, binary, or numerical, but the response variable must be numerical.) These data do not have to come from the same source, but should be compatible as data sets. Data should be cross-sectional (no time-series data). The minimum requirement is 50 observations with ten independent variables. [Beware the tautology: do not collect temperature and humidity to “predict” the heat index!] Ensure that your data set will allow you to draw relevant conclusions about something that matters. The data may be from any field (preferably business-related) and should be collected so that you can establish relationships among your data to support some sort of a conclusion or recommendation. Apply descriptive statistics to your data set. This should include graphical depictions (histograms and scatter plots) as well as some basic calculated descriptive statistics. Since you will be building a multivariate model, the correlations between your independent variables should be included. You should, at this point, be able to make some preliminary observations about your data. These observations (and any others you come up with later) should make their way into your business report, but will generally appear in appendices unless you determine them to be critical to the decision you are recommending. This submission should be a word document (for the descriptive stats) and an excel file (for the data). Phase II: Model Construction and Business Report Build a multiple regression model from your data using the techniques we have learned in the course. You should decide here how you intend to use your model to conduct analysis, make predictions, and support decisions. Wrap all of your work up in a business report. Remember that the target is an executive who you will ask for a decision based on your recommendation. Perform analysis with your model, interpret your model, include your calculations and the original data (in appendices) but present the bottom line to the decision-maker up front. While many organizations suggest a format for a business report, there are as many that do not, so the presentation is up to you. However, the following page may be used as a guideline. Business Report Format (Suggested) Cover Sheet Title. Indicate who the report is for, and what the report is about. (Use this to establish the “setting” for your instructor to grade your submission.) Your name and position. (Again to establish context for the grader.) Executive Summary. A single paragraph that an executive can read and immediately know what decision you are recommending and why. Main Body A 2-3 page report that tells the executive what decision should be made, and why the decision should be what it is. This should reference (and may include) the model you are using to support the decision-making process, and may also describe how confident the executive should be when making this decision. (In extreme cases the report can go up to 5 pages. Business reports not intended for senior executives may be longer, based on the organization’s needs.) BLUF! (Bottom Line Up Front!) The decision should be clear after the first few sentences, and definitely by the end of the first paragraph. Include only that information that will be critical to the executive’s decision-making process. Refer to all supporting data and analyses that are included in appendices. Appendices should appear in order of importance, and should be referenced in that order. Appendices (this shows one possible way of organizing your supporting information) AModel and Interpretation (Show the final model you developed to support the decision, and interpret it, to include discussing the effects of the ranges of your input variables.) BModel Statistical Analysis (Discuss the strength of the model in terms of how it supports the decision-making process. Include the relevant Excel output that supports the quality of the model.) CModel Development (Brag about the process you used to turn the data into a model. Discuss variable elimination and transformation, as well as any other clever modeling techniques you used. You do not have to include every step of your process, but you should show critical analyses that led to important modeling decisions.) DData Analysis (Show your descriptive and graphical analysis of the data, to include all the observations that might contribute to the modeling process.) EData Describe the data set and include the sources. For very small data sets you may include them. For small data sets (hundreds of observations) or larger, do not waste your company’s paper. Dataset SuburbAddressRoomsTypePriceMethodSellerGDateDistancePostcodeBedroom2BathroomCarLandsizeBuildingAreaYearBuiltCouncilAreaLattitudeLongtitudeRegionnamePropertycount Abbotsford25 Bloomburg St2h1035000SBiggin2/4/162.53067210156791900Yarra City Council-37.8079144.9934Northern Metropolitan4019 Abbotsford5 Charles St3h1465000SPBiggin3/4/172.530673201341501900Yarra City Council-37.8093144.9944Northern Metropolitan4019 Abbotsford55a Park St4h1600000VBNelson6/4/162.530673121201422014Yarra City Council-37.8072144.9941Northern Metropolitan4019 Abbotsford124 Yarra St3h1876000SNelson5/7/162.530674202452101910Yarra City Council-37.8024144.9993Northern Metropolitan4019 Abbotsford98 Charles St2h1636000SNelson10/8/162.530672122561071890Yarra City Council-37.806144.9954Northern Metropolitan4019 Abbotsford10 Valiant St2h1097000SBiggin10/8/162.53067312220751900Yarra City Council-37.801144.9989Northern Metropolitan4019 Abbotsford40 Nicholson St3h1350000VBNelson11/12/162.530673222141902005Yarra City Council-37.8085144.9964Northern Metropolitan4019 Abbotsford16 William St2h1310000SJellis10/15/162.53067212238971890Yarra City Council-37.809144.9976Northern Metropolitan4019 Abbotsford42 Henry St3h1200000SJellis7/16/162.530673211131101880Yarra City Council-37.8056144.993Northern Metropolitan4019 Abbotsford78 Yarra St3h1176500SLITTLE7/16/162.530672111381051890Yarra City Council-37.8021144.9965Northern Metropolitan4019 Abbotsford42 Valiant St2h890000SBiggin9/17/162.53067211150731985Yarra City Council-37.8011145.0004Northern Metropolitan4019 Abbotsford3/72 Charles St4h1330000PIKay3/18/172.530674227801351900Yarra City Council-37.8073144.9952Northern Metropolitan4019 Abbotsford52a William St2h1100000PIBiggin6/18/162.530672211241352013Yarra City Council-37.8079144.9977Northern Metropolitan4019 Abbotsford49 Park St2h1315000SMarshall11/19/162.53067210147851900Yarra City Council-37.808144.994Northern Metropolitan4019 Abbotsford48 Abbotsford St3h1447500PINelson8/22/162.530673311661742012Yarra City Council-37.8017145.0001Northern Metropolitan4019 Abbotsford159 Park St2h1135000SNelson8/22/162.53067222981281920Yarra City Council-37.8005144.9952Northern Metropolitan4019 Abbotsford60 Stafford St3h1290000SBiggin2/25/172.530673111681241950Yarra City Council-37.8007144.9958Northern Metropolitan4019 Abbotsford47 Studley St2h1180000SJellis11/27/162.53067210162911900Yarra City Council-37.8016144.9956Northern Metropolitan4019 Abbotsford45 Yarra St3h1195000SPJellis11/27/162.530673211201281998Yarra City Council-37.8022144.9954Northern Metropolitan4019 Abbotsford200 Nicholson St2h1012500SNelson5/28/162.53067210182821900Yarra City Council-37.8021144.9976Northern Metropolitan4019 Abbotsford27 Charles St2h1030000SBiggin7/30/162.53067211172811930Yarra City Council-37.8086144.9946Northern Metropolitan4019 Airport West154 Halsey Rd3t840000PINelson9/3/1613.530423213032252016Moonee Valley City Council-37.718144.878Western Metropolitan3464 Airport West23 Hart St2h603000SNelson3/4/1713.53042211272841950Moonee Valley City Council-37.7294144.888Western Metropolitan3464 Airport West1/80 Hawker St3t700000SBrad3/4/1713.530423222391342009Moonee Valley City Council-37.7218144.8837Western Metropolitan3464 Airport West1/37 Hillside Gr3h600000SMaddison3/4/1713.530422112901161980Moonee Valley City Council-37.7273144.8744Western Metropolitan3464 Airport West2/49 McIntosh St2u500000VBBarry3/4/1713.53042211168862011Moonee Valley City Council-37.7215144.8864Western Metropolitan3464 Airport West11 Harrington Rd6h725000SPBarry5/7/1613.530426329761861980Moonee Valley City Council-37.7239144.8735Western Metropolitan3464 Airport West2/252 Parer Rd2t450000SBarry5/7/1613.53042211110902015Moonee Valley City Council-37.7216144.871Western Metropolitan3464 Airport West3/19 Hart St2u515000SBarry11/7/1613.53042211141732013Moonee Valley City Council-37.7298144.8883Western Metropolitan3464 Airport West2/62 Clydesdale Rd2u530000SNelson9/10/1613.53042211120942012Moonee Valley City Council-37.7234144.8792Western Metropolitan3464 Airport West3 Deidre Ct3h895000PIRendina9/10/1613.5304231610631331975Moonee Valley City Council-37.7249144.8728Western Metropolitan3464 Airport West1/43 Cameron St3u752000SNelson2/11/1713.530423112651301993Moonee Valley City Council-37.7302144.8855Western Metropolitan3464 Airport West2/40 Earl St3t700000PIBrad10/15/1613.530423221651332009Moonee Valley City Council-37.727144.887Western Metropolitan3464 Airport West180 Parer Rd3h830000SBarry4/16/1613.530423129711131960Moonee Valley City Council-37.7186144.876Western Metropolitan3464 Airport West174 Parer Rd2h675000SBarry7/16/1613.530422116121001975Moonee Valley City Council-37.7187144.8765Western Metropolitan3464 Airport West138 Victory Rd3h1042000SNelson7/16/1613.530423256121741950Moonee Valley City Council-37.7173144.8796Western Metropolitan3464 Airport West6 Kittyhawk St4h773000SBrad9/17/1613.530425345313091980Moonee Valley City Council-37.7263144.8679Western Metropolitan3464 Airport West478 Fullarton Rd3h810000PIBarry3/18/1713.530423325551921980Moonee Valley City Council-37.7285144.8694Western Metropolitan3464 Airport West144 Marshall Rd3h715000SRendina3/18/1713.530423224221261995Moonee Valley City Council-37.7164144.8792Western Metropolitan3464 Airport West3/7 South Rd3t540000SPNelson6/18/1613.530422211611012010Moonee Valley City Council-37.7231144.8802Western Metropolitan3464 Airport West37 North St3t825000SPBarry11/19/1613.530423212931021960Moonee Valley City Council-37.72144.8776Western Metropolitan3464 Airport West10 Hilbert Rd3h685000SBarry5/22/1613.530423115791131975Moonee Valley City Council-37.7226144.8733Western Metropolitan3464 Airport West85 Roberts Rd4h900000SHarcourts11/27/1613.530424236281461975Moonee Valley City Council-37.7256144.8739Western Metropolitan3464 Albert Park105 Kerferd Rd2h1275000Shockingstuart9/3/163.33206210120821900Port Phillip City Council-37.8459144.9555Southern Metropolitan3280 Albert Park112 Beaconsfield Pde3h2850000PIBuxton3/4/173.332063202111981890Port Phillip City Council-37.8481144.9499Southern Metropolitan3280 Albert Park94 Graham St3h1850000SGreg3/4/173.332063201281331890Port Phillip City Council-37.8452144.9488Southern Metropolitan3280 Albert Park396 Montague St2h1436000SRT3/4/173.33206210130811900Port Phillip City Council-37.8431144.9565Southern Metropolitan3280 Albert Park104 Richardson St4h2300000SMarshall5/7/163.332064211531801880Port Phillip City Council-37.8447144.9523Southern Metropolitan3280 Albert Park1 Moubray St3h1800000VBGreg11/7/163.332063211321591996Port Phillip City Council-37.8415144.952Southern Metropolitan3280 Albert Park29 Faussett St2h2120000SGreg9/10/163.332062111991071900Port Phillip City Council-37.8422144.9554Southern Metropolitan3280 Albert Park24 Kerferd Pl3h1800000SMarshall9/10/163.33206321901221900Port Phillip City Council-37.8421144.9571Southern Metropolitan3280 Albert Park2 Dundas Pl3h2615000SCayzer12/10/163.332063211771811880Port Phillip City Council-37.8415144.9585Southern Metropolitan3280 Albert Park65 Graham St2h1322500SGreg10/15/163.33206210149981890Port Phillip City Council-37.8443144.9481Southern Metropolitan3280 Albert Park364 Montague St2h1562500SGreg10/15/163.33206210141831890Port Phillip City Council-37.8424144.9562Southern Metropolitan3280 Albert Park86 Mills St3h2000000VBRT4/16/163.332063212111471900Port Phillip City Council-37.847144.9575Southern Metropolitan3280 Albert Park97 Page St3h3010000SGreg3/18/173.332063201471461890Port Phillip City Council-37.8473144.9551Southern Metropolitan3280 Albert Park55 Withers St4h2800000VBCayzer6/18/163.332064313272541910Port Phillip City Council-37.8467144.9475Southern Metropolitan3280 Albert Park55 Merton St3h2100000SPMarshall4/23/163.332062111201231900Port Phillip City Council-37.8427144.9546Southern Metropolitan3280 Albert Park49 Page St3h2000000PIMarshall9/24/163.332063112381311890Port Phillip City Council-37.8461144.9528Southern Metropolitan3280 Albert Park115 Page St4h4735000SMarshall2/25/173.332064213302071910Port Phillip City Council-37.8477144.9558Southern Metropolitan3280 Albert Park27 Barrett St4h2140000SGreg6/27/163.332063211831451880Port Phillip City Council-37.8434144.9495Southern Metropolitan3280 Albert Park6 Brooke St2h980000SGreg5/28/163.3320621079681890Port Phillip City Council-37.8387144.9519Southern Metropolitan3280 Albert Park17 Reed St3h1740000PIMarshall8/28/163.332063221471341890Port Phillip City Council-37.8448144.9453Southern Metropolitan3280 Albert Park9 Durham St1h985000SMarshall7/30/163.3320611081541900Port Phillip City Council-37.8411144.9497Southern Metropolitan3280 Alphington6 Smith St4h2000000SBrace9/3/166.430783248532631930Darebin City Council-37.7707145.0318Northern Metropolitan2211 Alphington44 Shiers St4h1717500SCollins10/8/166.430784215992031925Darebin City Council-37.7717145.031Northern Metropolitan2211 Alphington83 Fulham Rd5h2840000SNelson6/12/166.430785448091651910Darebin City Council-37.775145.0268Northern Metropolitan2211 Alphington3/19 Harker St2u525500SMiles11/12/166.4307821188601960Darebin City Council-37.7791145.0306Northern Metropolitan2211 Alphington4/2 Miller St2t805000SMiles11/12/166.430782231551402004Darebin City Council-37.7804145.0308Northern Metropolitan2211 Alphington10 Bennett St4h1830000SNelson11/19/166.430784226061121970Darebin City Council-37.7743145.0316Northern Metropolitan2211 Alphington38 Bennett St4h2100000SNelson11/19/166.430784225752712008Darebin City Council-37.7723145.0319Northern Metropolitan2211 Alphington2c Hamilton St3h865000SPhockingstuart5/22/166.430783111801312010Darebin City Council-37.7802145.0243Northern Metropolitan2211 Alphington11 Margaret Gr4h1900000SPMcGrath11/27/166.430784225562721930Darebin City Council-37.7844145.0225Northern Metropolitan2211 Alphington42 Shiers St4h1950000SJellis7/30/166.430784235892101920Darebin City Council-37.7719145.0309Northern Metropolitan2211 Altona158 Queen St3h520000VBGreg9/3/1613.830183213522422015Hobsons Bay City Council-37.87144.825Western Metropolitan5301 Altona59 Bracken Gr5h1525000SGreg12/3/1613.830185337292682005Hobsons Bay City Council-37.8721144.8105Western Metropolitan5301 Altona1/123 Blyth St2t720000Shockingstuart2/4/1613.830182122921252013Hobsons Bay City Council-37.8687144.8197Western Metropolitan5301 Altona4 Blyth St3h1120000SBarlow3/4/1713.830183125061201930Hobsons Bay City Council-37.8693144.8375Western Metropolitan5301 Altona29 Rose St4h1780000SPGreg6/4/1613.8301843610572201962Hobsons Bay City Council-37.8681144.819Western Metropolitan5301 Altona1/170 Blyth St3u630000SBarlow8/6/1613.83018212311941955Hobsons Bay City Council-37.8702144.8143Western Metropolitan5301 Altona156 Maidstone St3h660000VBGreg5/7/1613.830183116021231955Hobsons Bay City Council-37.8616144.8116Western Metropolitan5301 Altona1/136 Queen St2u580000SBarlow10/8/1613.83018211225931988Hobsons Bay City Council-37.8696144.827Western Metropolitan5301 Altona173 Queen St3h1335000Shockingstuart10/8/1613.83018314777221953Hobsons Bay City Council-37.8697144.8249Western Metropolitan5301 Altona3/26 Grieve Pde2u510000SVillage9/10/1613.83018211127761990Hobsons Bay City Council-37.8686144.8182Western Metropolitan5301 Altona4/5 Rose St2u425000Shockingstuart9/10/1613.83018212115571980Hobsons Bay City Council-37.871144.8185Western Metropolitan5301 Altona24 Wren St4h845000Shockingstuart2/11/1713.830184127451301950Hobsons Bay City Council-37.8658144.8155Western Metropolitan5301 Altona4/57 Blyth St3u730000SPBarlow8/13/1613.83018321691412014Hobsons Bay City Council-37.868144.8286Western Metropolitan5301 Altona3/46 Sargood St2u447000SBurnham10/15/1613.83018211137771990Hobsons Bay City Council-37.8655144.8299Western Metropolitan5301 Altona22 Fenfield St3h678000Shockingstuart4/16/1613.83018312606871950Hobsons Bay City Council-37.8608144.8124Western Metropolitan5301 Altona5/8 David St2u580000PIBiggin7/16/1613.83018221175762013Hobsons Bay City Council-37.8687144.8268Western Metropolitan5301 Altona27 McIntyre Dr3h840000SPGreg3/18/1713.830183225341361965Hobsons Bay City Council-37.86144.8245Western Metropolitan5301 Altona3/20 Mulga St3u577000SWilliams4/23/1613.830183212051132007Hobsons Bay City Council-37.8684144.815Western Metropolitan5301 Altona104 Maidstone St2h857000SPhockingstuart11/27/1613.830182216751001950Hobsons Bay City Council-37.8653144.8129Western Metropolitan5301 Altona5/57 Blyth St3u730000SPBarlow5/28/1613.830183217032014Hobsons Bay City Council-37.868144.8285Western Metropolitan5301 Altona2/60 David St2h535600SPCompton7/30/1613.83018211154911996Hobsons Bay City