help!!

Chapter 22: Bivariate Analysis Assignment. Two Sample T-Test Attached Files: auto_data.xls (20.5 KB) Research Analysis Assignment Outline.docx A (15.206 KB) Using the Auto Data set, which describes a set of vehicles and their prices in the 1970s, use a bivariate model to work through the Business Research Process using the attached outline document to construct your response. Under sections where this methodology does not provide an appropriate response, state as much In this scenario you can take the perspective of an auto buyer, seller, dealer, inspector, etc. You may be interested in engine size, price or any other variable. Pick a topic of interest and use it to build out the research question and the succeeding questions using the Assignment Outline provided. Take some liberty with your ideas and build it out knowing what the collected dataset looks like. The second half of the research process, particularly the Data Processing and Analysis portiort should be constructed using the dataset provided following your declared research question and research objectives. Use some creativity but follow your research objective to the end of the assignment once it is selected. Practice using both Tableau and Excel to build out your graphs/tables/vizualizations In order for a bivariate (two sample) example to work we must select two different groups and measure them using the same variabile, in this case, use the foreign vs domestic variable Examples of questions of interest may include: Is there a difference in prices between Domestic and foreign vehicles? is there a difference in engine sites between Domestic and Foreign vehicles? Using the research question and dataset provided, answer the following questions. Provide graphics and tables where appropriate. Make an effort to explain your logic and decisions. 1) Problem Discovery a. Describe the problem. b. What exploratory technique is the best fit to identify the research question? Why? c. What is the research question? d. What do you believe the results/relationship will be? e. State the Hypothesis and the Null Hypothesis 1. In English II. In Math : (x > 3) 2) Planning Research Design a. Identify and Describe the best research method(s) to collect data for the research. b. Why would this method be best? 3) Sampling a. What type of sampling would you suggest for data collection? b. Describe the sampling technique. c. What are the benefits and drawbacks of this sampling design? 4) Data Gathering a. Describe the data set, variables and how it was obtained. b. Identify the dependent variable. c. Provide an explanatory table/graph of the data. I. This should be an interesting description that says something about the data or maybe why its important. Bar/line/pie or similar d. Descriptive Table 1. This should be a Descriptive table that include Mean, Median, Max, Min and Standard Deviation of the variable(s) li. Make it a standalone table H. But describe in in the text 5) Data Processing and Analysis a. Describe the statistical process used and why it was selected. b. Write the statistical model in equation form. c. Results Table (table) d. Is this model significant? At what level? e. Provide a table/graphic if appropriate. 6) Conclusions a. What is the conclusion of your research? (one sentence) b. How does this compare to your original belief? What bias(es) did you bring to this work? c. AD4 x & fx mog 163 1 make 2 AMG Concord AMC Pacer ANC Sort 6 Buick Century 6 Buick Electra * Buick LeSabre Buick Opel Buick Regal 10 Buick Rien 11 Buick Skylar 12. Cad. Deville 13 Cad. Eldorado 14 Cad Sevilo 15 Chev. Chevette 18 Chev. Impala 17 Chev. Malibu 18 Chev. Monte Carlo 10 Chev Monza 20 Chev. Nova 21 Dodge Cott 22 Dodge Diplomat 23 Dodge Magnum 24 Dodge St Regis 25. Ford Fema 26 Ford Mustang 27 Line, Continental 28 Line Mark V 20 Linc. Versalles 30 Merc. Bobcat 31 Mere Cougar 32 Marc Marquia 33 Merc, Monarch 34 Mer XR-7 35 Mere Zephyr 30 Olds 37 Olds Cuti Supe 38 Olds Cutlass 30 Olds Delta 88 40 Olds Omega 41 Olds Startre 42 Olde Toronado 43 Plym Arrow 44 Plym Champ 45 Plym Horizon 46 Plyn Sapporo 47 Plyn, Volare 40 Pont Catalina 49 Pont. Firebird 50 Pont Grand Prix 51 Pont Le Mang 62 Pont Phoenb 53 Pont. Sunbud 54 Audi 5000 55 Audi Fox 56 BMW 320i 57 Datsun 200 58 Datsun 210 59 Daten $10 00 Daten 810 81 Fat Strada 2 Honda Accord 61 Honda Civic 4 Manda OLC 05 Peugeot 604 10 Ranaut Le Car o Suban 8 price 4000 4749 3790 4810 7827 5788 4453 5180 10372 4082 11385 14500 15006 3290 5705 4504 5104 3667 3955 3984 4010 5886 5342 4389 4187 11497 13504 13466 3829 5379 6165 4516 0303 3291 8810 5172 4733 4890 4181 4196 10371 4647 4425 4482 6488 4060 5798 4934 5222 4723 4424 4172 0500 6295 9735 8229 4589 5079 8129 4296 5799 4499 3905 12690 3895 3705 FANS + D rep76 22 Average 17 Average 22 20 Average 15 Good 18 Average 26 20 Average 16 Average 19 Average 14 Average 14 Far 21 Average 20 Average 16 Good 22 Average 22 Far 24 Fair 19 Average 30 Excelent 15 Far 16 Far 17 Fair 28 Good 21 Average 12 Average 12 Average 14 Average 22 Good 14 Good 15 Average 18 Average 14 Good 20 Average 21 Good 19 Average 19 Average 18 Good 19 Average 24 Poor 16 Average 28 Average 34 Excelent 25 Average 26 18 Far 18 Good 18 Poor 19 Averago 19 Average 19 24 Fair 17 Excellent 23 Average 25 Good 23 Good 35 Excelent 24 Good 21 Good 21 Average 25 Excellent 28 Good 30 Good 14 26 Average 35 Excelent F G L headroom trunk weight length tum displaceme gear_ratio forn 2.5 2930 Se 40 121 2.58 Donete 3 11 3350 173 40 250 3 12 2.53 Domestic 2640 108 35 4.5 121 308 Domestic 16 3250 196 40 4 20 196 2.99 Domestie 4000 222 43 350 241 Domestic 4 21 3670 218 43 231 273 Domestic 3 10 2730 170 304 2 2.87 Domestic 16 3280 200 42 106 35 2.99 Domestic 17 3880 207 43 35 231 2.99 Domestic 13 3400 200 42 231 3.08 Domestic 4 20 4330 221 44 35 425 2.28 Dometic 18 3900 204 43 350 219 Dames 3 13 4290 204 45 350 2.24 Domestic 25 9 2110 163 34 231 2.93 Domestic 4 20 212 43 250 256 Dome 17 193 31 200 2.73 Domestic 2 16 200 41 200 2 2.73 Domestic 7 2750 179 40 151 2.73 Domestic 3.5 13 3630 197 43 250 2.56 Domestic 2 8 2120 35 98 354 Domestic 4 17 3600 206 45 318 247 Domestic 4 97 3600 206 46 316 2.47 Domestic 4,5 21 3740 220 48 225 24 Domestic 1.5 9 1800 147 33 06 3.15 Domestic 2 10 2650 179 3) 2) Planning Research Design a. Identify and Describe the best research method(s) to collect data for the research. b. Why would this method be best? 3) Sampling a. What type of sampling would you suggest for data collection? b. Describe the sampling technique. c. What are the benefits and drawbacks of this sampling design? 4) Data Gathering a. Describe the data set, variables and how it was obtained. b. Identify the dependent variable. c. Provide an explanatory table/graph of the data. I. This should be an interesting description that says something about the data or maybe why its important. Bar/line/pie or similar d. Descriptive Table 1. This should be a Descriptive table that include Mean, Median, Max, Min and Standard Deviation of the variable(s) li. Make it a standalone table H. But describe in in the text 5) Data Processing and Analysis a. Describe the statistical process used and why it was selected. b. Write the statistical model in equation form. c. Results Table (table) d. Is this model significant? At what level? e. Provide a table/graphic if appropriate. 6) Conclusions a. What is the conclusion of your research? (one sentence) b. How does this compare to your original belief? What bias(es) did you bring to this work? c. AD4 x & fx mog 163 1 make 2 AMG Concord AMC Pacer ANC Sort 6 Buick Century 6 Buick Electra * Buick LeSabre Buick Opel Buick Regal 10 Buick Rien 11 Buick Skylar 12. Cad. Deville 13 Cad. Eldorado 14 Cad Sevilo 15 Chev. Chevette 18 Chev. Impala 17 Chev. Malibu 18 Chev. Monte Carlo 10 Chev Monza 20 Chev. Nova 21 Dodge Cott 22 Dodge Diplomat 23 Dodge Magnum 24 Dodge St Regis 25. Ford Fema 26 Ford Mustang 27 Line, Continental 28 Line Mark V 20 Linc. Versalles 30 Merc. Bobcat 31 Mere Cougar 32 Marc Marquia 33 Merc, Monarch 34 Mer XR-7 35 Mere Zephyr 30 Olds 37 Olds Cuti Supe 38 Olds Cutlass 30 Olds Delta 88 40 Olds Omega 41 Olds Startre 42 Olde Toronado 43 Plym Arrow 44 Plym Champ 45 Plym Horizon 46 Plyn Sapporo 47 Plyn, Volare 40 Pont Catalina 49 Pont. Firebird 50 Pont Grand Prix 51 Pont Le Mang 62 Pont Phoenb 53 Pont. Sunbud 54 Audi 5000 55 Audi Fox 56 BMW 320i 57 Datsun 200 58 Datsun 210 59 Daten $10 00 Daten 810 81 Fat Strada 2 Honda Accord 61 Honda Civic 4 Manda OLC 05 Peugeot 604 10 Ranaut Le Car o Suban 8 price 4000 4749 3790 4810 7827 5788 4453 5180 10372 4082 11385 14500 15006 3290 5705 4504 5104 3667 3955 3984 4010 5886 5342 4389 4187 11497 13504 13466 3829 5379 6165 4516 0303 3291 8810 5172 4733 4890 4181 4196 10371 4647 4425 4482 6488 4060 5798 4934 5222 4723 4424 4172 0500 6295 9735 8229 4589 5079 8129 4296 5799 4499 3905 12690 3895 3705 FANS + D rep76 22 Average 17 Average 22 20 Average 15 Good 18 Average 26 20 Average 16 Average 19 Average 14 Average 14 Far 21 Average 20 Average 16 Good 22 Average 22 Far 24 Fair 19 Average 30 Excelent 15 Far 16 Far 17 Fair 28 Good 21 Average 12 Average 12 Average 14 Average 22 Good 14 Good 15 Average 18 Average 14 Good 20 Average 21 Good 19 Average 19 Average 18 Good 19 Average 24 Poor 16 Average 28 Average 34 Excelent 25 Average 26 18 Far 18 Good 18 Poor 19 Averago 19 Average 19 24 Fair 17 Excellent 23 Average 25 Good 23 Good 35 Excelent 24 Good 21 Good 21 Average 25 Excellent 28 Good 30 Good 14 26 Average 35 Excelent F G L headroom trunk weight length tum displaceme gear_ratio forn 2.5 2930 Se 40 121 2.58 Donete 3 11 3350 173 40 250 3 12 2.53 Domestic 2640 108 35 4.5 121 308 Domestic 16 3250 196 40 4 20 196 2.99 Domestie 4000 222 43 350 241 Domestic 4 21 3670 218 43 231 273 Domestic 3 10 2730 170 304 2 2.87 Domestic 16 3280 200 42 106 35 2.99 Domestic 17 3880 207 43 35 231 2.99 Domestic 13 3400 200 42 231 3.08 Domestic 4 20 4330 221 44 35 425 2.28 Dometic 18 3900 204 43 350 219 Dames 3 13 4290 204 45 350 2.24 Domestic 25 9 2110 163 34 231 2.93 Domestic 4 20 212 43 250 256 Dome 17 193 31 200 2.73 Domestic 2 16 200 41 200 2 2.73 Domestic 7 2750 179 40 151 2.73 Domestic 3.5 13 3630 197 43 250 2.56 Domestic 2 8 2120 35 98 354 Domestic 4 17 3600 206 45 318 247 Domestic 4 97 3600 206 46 316 2.47 Domestic 4,5 21 3740 220 48 225 24 Domestic 1.5 9 1800 147 33 06 3.15 Domestic 2 10 2650 179