Question: Elements to Include: Perform a regression analysis for predicated reliability and price to develop an estimated regression equation that could be used to predict the
Elements to Include:
- Perform a regression analysis for predicated reliability and price to develop an estimated regression equation that could be used to predict the reliability and price.
- Plot the data on a scatterplot with the trend line. (Show your regression calculations.)
- Discuss your R-squared findings and what it indicates.
Final Assembly
- Title page
- Abstract: A one paragraph summary of what the project was about, what you learned, and what you ended up finding. It should summarize the entire report.
- Introduction: A discussion of what questions you are interested in.
- Data Set: Describe how the data was used and the results of your calculations. Be sure to embed the graphs and charts into your Word document or audio/visual presentation.
- Analysis: Discuss what the data told you. Was anything surprising? What other questions do you have about the results and the data? From the results, which car do you believe would be the best fit for your needs.
- Limitations of study and conclusion: Describe any limitations of this study and how those limitations may have hindered this study. What would you like to see in future studies of this type? Should other variables be considered and if so, which ones?
- Reference page in APA format with at least two outside, non-textbook sources.
The final submission will be in one of the following formats:
1. Typewritten: Written reports should be at least four (4) pages in length for the body of the paper, double-spaced, and contain good grammar and punctuation. Include headings for each section and references and address all the elements below. Use Times New Roman, Size 12 font with 1 margins all around and, when applicable, include graphs and/or tables (imbedded from Excel or other statistical software). Include a title page and at least two non-textbook references in APA formatting.
2. Audio/visual PowerPoint Presentation: A minimum of ten (10) slides must be submitted or enough slides to cover each part of the project and all the elements below, i.e., abstract, introduction, data set, analysis, and limitations. Audio must be included and be clear without background noise. Visual PowerPoint background and color must be professional and not contain inappropriate text, pictures, graphs, and tables. When applicable, graphs and tables must also be included in PowerPoint slides and discussed. Font size for titles should be no larger than 32. Font size for the body should be no larger than 24 and no smaller than 20. Include a title page and references in APA formatting.
| Car | Predicted Reliability | Value Score | Price ($) | Cost/Mile | Road-Test Score |
| Nissan Altima 2.5 S (4-cyl.) | 4 | 1.75 | 23,970.00 | 0.59 | 91 |
| Kia Optima LX (2.4) | 4 | 1.73 | 21,885.00 | 0.58 | 81 |
| Subaru Legacy 2.5i Premium | 4 | 1.73 | 23,830.00 | 0.59 | 83 |
| Ford Fusion Hybrid | 5 | 1.70 | 32,360.00 | 0.63 | 84 |
| Honda Accord LX-P (4-cyl.) | 4 | 1.62 | 23,730.00 | 0.56 | 80 |
| Mazda6 i Sport (4-cyl.) | 4 | 1.60 | 22,035.00 | 0.58 | 73 |
| Hyundai Sonata GLS (2.4) | 3 | 1.58 | 21,800.00 | 0.56 | 89 |
| Ford Fusion SE (4-cyl.) | 4 | 1.55 | 23,625.00 | 0.57 | 76 |
| Chevrolet Malibu LT (4-cyl.) | 3 | 1.48 | 24,115.00 | 0.57 | 74 |
| Kia Optima SX (2.0T) | 4 | 1.43 | 29,050.00 | 0.72 | 84 |
| Ford Fusion SEL (V6) | 4 | 1.42 | 28,400.00 | 0.67 | 80 |
| Nissan Altima 3.5 SR (V6) | 4 | 1.42 | 30,335.00 | 0.69 | 93 |
| Hyundai Sonata Limited (2.0T) | 3 | 1.39 | 28,090.00 | 0.66 | 89 |
| Honda Accord EX-L (V6) | 3 | 1.36 | 28,695.00 | 0.67 | 90 |
| Mazda6 s Grand Touring (V6) | 4 | 1.34 | 30,790.00 | 0.74 | 81 |
| Ford Fusion SEL (V6, AWD) | 4 | 1.32 | 30,055.00 | 0.71 | 75 |
| Subaru Legacy 3.6R Limited | 3 | 1.29 | 30,094.00 | 0.71 | 88 |
| Chevrolet Malibu LTZ (V6) | 3 | 1.20 | 28,045.00 | 0.67 | 83 |
| Chrysler 200 Limited (V6) | 5 | 1.20 | 27,825.00 | 0.70 | 52 |
| Chevrolet Impala LT (3.6) | 3 | 1.05 | 28,995.00 | 0.67 | 63 |
| Lexus ES350 (V6) | 4 | 1.52 | 35,785.00 | 0.75 | 99 |
| Row Labels | Sum of Price ($) | Sum of Predicted Reliability |
| Chevrolet Impala LT (3.6) | 28995 | 3 |
| Chevrolet Malibu LT (4-cyl.) | 24115 | 3 |
| Chevrolet Malibu LTZ (V6) | 28045 | 3 |
| Chrysler 200 Limited (V6) | 27825 | 5 |
| Ford Fusion Hybrid | 32360 | 5 |
| Ford Fusion SE (4-cyl.) | 23625 | 4 |
| Ford Fusion SEL (V6, AWD) | 30055 | 4 |
| Ford Fusion SEL (V6) | 28400 | 4 |
| Honda Accord EX-L (V6) | 28695 | 3 |
| Honda Accord LX-P (4-cyl.) | 23730 | 4 |
| Hyundai Sonata GLS (2.4) | 21800 | 3 |
| Hyundai Sonata Limited (2.0T) | 28090 | 3 |
| Kia Optima LX (2.4) | 21885 | 4 |
| Kia Optima SX (2.0T) | 29050 | 4 |
| Lexus ES350 (V6) | 35785 | 4 |
| Mazda6 i Sport (4-cyl.) | 22035 | 4 |
| Mazda6 s Grand Touring (V6) | 30790 | 4 |
| Nissan Altima 2.5 S (4-cyl.) | 23970 | 4 |
| Nissan Altima 3.5 SR (V6) | 30335 | 4 |
| Subaru Legacy 2.5i Premium | 23830 | 4 |
| Subaru Legacy 3.6R Limited | 30094 | 3 |
| Grand Total | 573509 | 79 |
| Predicted Reliability | Value Score | Price ($) | Cost/Mile | Road-Test Score | |||||
| Mean | 3.761905 | Mean | 1.460952 | Mean | 27309.95238 | Mean | 0.647143 | Mean | 81.33333 |
| Standard Error | 0.13636 | Standard Error | 0.042099 | Standard Error | 833.4492742 | Standard Error | 0.013992 | Standard Error | 2.283829 |
| Median | 4 | Median | 1.43 | Median | 28090 | Median | 0.67 | Median | 83 |
| Mode | 4 | Mode | 1.73 | Mode | #N/A | Mode | 0.67 | Mode | 81 |
| Standard Deviation | 0.624881 | Standard Deviation | 0.192922 | Standard Deviation | 3819.344387 | Standard Deviation | 0.06412 | Standard Deviation | 10.46582 |
| Sample Variance | 0.390476 | Sample Variance | 0.037219 | Sample Variance | 14587391.55 | Sample Variance | 0.004111 | Sample Variance | 109.5333 |
| Kurtosis | -0.36491 | Kurtosis | -0.51453 | Kurtosis | -0.504175938 | Kurtosis | -1.48615 | Kurtosis | 2.136733 |
| Skewness | 0.195159 | Skewness | -0.23076 | Skewness | 0.181502114 | Skewness | -0.03704 | Skewness | -1.10321 |
| Range | 2 | Range | 0.7 | Range | 13985 | Range | 0.19 | Range | 47 |
| Minimum | 3 | Minimum | 1.05 | Minimum | 21800 | Minimum | 0.56 | Minimum | 52 |
| Maximum | 5 | Maximum | 1.75 | Maximum | 35785 | Maximum | 0.75 | Maximum | 99 |
| Sum | 79 | Sum | 30.68 | Sum | 573509 | Sum | 13.59 | Sum | 1708 |
| Count | 21 | Count | 21 | Count | 21 | Count | 21 | Count | 21 |
| Predicted Reliability | Value Score | Price | Cost/Mile | Road-test Score | |||||
| Mean | 3.761905 | Mean | 1.460952 | Mean | 27309.95238 | Mean | 0.647143 | Mean | 81.33333 |
| Median | 4 | Median | 1.43 | Median | 28090 | Median | 0.67 | Median | 83 |
| Mode | 4 | Mode | 1.73 | Mode | #N/A | Mode | 0.67 | Mode | 83 |
| Predicted Reliability | Value Score | Price | Cost/Mile | Road-test Score | |||||
| Standard Deviation | 0.624881 | Standard Deviation | 0.192922 | Standard Deviation | 3819.344387 | Standard Deviation | 0.06412 | Standard Deviation | 10.46582 |
| Price and Cost/mile | 0.861 | strong linear association |
| Price and Road-test score | 0.0488 | very weak association |
| Price and Predicted Relaibility | 0.1168 | very weak association |
| Road-test score and Predicted Relaibility | -0.3142 | negative moderate linear association |
| The upper and lower limits for Car Purchase Price | |
| Mean | 27,309.95 |
| Standard deviation | 3819.344387 |
| Count | 21 |
| The Confidenc | 1633.53056 |
| Upper Limt | 28,943.48 |
| Lower Limit | 25,676.42 |
| The upper and lower limits for Road Test Score | |
| Mean | 81.33333333 |
| Standard deviation | 10.46581738 |
| Count | 21 |
| The Confidenc | 4.476221778 |
| Upper Limt | 85.80955511 |
| Lower Limit | 76.85711156 |
Can you help me make a PowerPoint Presentation please
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help