excel data analytics engagement project
- Export the SAS cars data to Excel (In your SASHELP library in SAS Studio, right click on CARS, select export, and export as an Excel or csv file). Select a folder within your SAS files area and export to that folder. Find the file you exported and download it to your computer.
- Open the file within Excel. If you cannot export as an Excel file, ensure that you export as a csv – you will still be able to open the csv file from Excel.
- On a separate workbook page, recreate the scatter plot that you made in SAS comparing engine size to highway mpg. You should have one graph with two sets of dots.
- For each car type in the scatterplot, right click on any dot and select add trendline. Use linear option, display equation on chart and display R-squared value on chart.
- Add any chart elements you feel will make the scatterplots easier to read and understand. I strongly recommend that each plot has a title, axis labels, and a legend at the minimum.
- Using Data > Data Analytics in Excel, do a linear regression for each type of car. Put this output on the same page as your scatter plot. NOTE: If your regression coefficients do not match the trendline equation for each car type, double check your work!
- Use Excel to calculate the correlation coefficient using the =CORREL command for each car type. Additionally, calculate the coefficient of determination for each car type as well. Put these values near your regression output. Do these values match what you found in your regression output?
- If the engine size was 8L, what do you predict the MPG would be for each type of car? Show your work in the file.
- Explain what your results mean in a textbox near your plots. Pay attention to the regression equation, regression output, correlation, and the R-squared value. Do the equations do a good job explaining MPG? Why or why not? What changes might you make to improve the model? Show me that you understand regression analysis. Do not be too brief!
- Save the Excel file, name it, and upload it here. NOTE: You must use Excel 2016 to upload your file as the only file type accepted is *.xlsx.Excel Data Analytics Project Rubric
Excel Data Analytics Project RubricCriteria Ratings Pts This criterion is linked to a Learning Outcome
Raw Data & Filters10.0 pts
ExcellentRaw data shown on separate page. Clear how data was filtered to do graphs and regressions.9.0 pts
AverageRaw data included but not clear how it was filtered to do graphs and regressions.0.0 pts
PoorFile only shows filtered data without no indication of how it was obtained or project plagiarized.10.0 pts
This criterion is linked to a Learning Outcome
Graphs35.0 pts
ExcellentGraph had title, axis labels, legend, and two sets of filtered data included each with a trendline, regression equation, and R2. Only minor errors, if any, present.28.0 pts
Above AvgGraphs set up properly for two sets of data but missing at least one element or has one substantial error.21.0 pts
AverageGraphs missing several required elements and/or have 1-2 significant errors.14.0 pts
Below AvgGraph has numerous missing elements or multiple significant errors.7.0 pts
PoorGraph missing most required elements or serious errors made, not done, or plagiarized.35.0 pts
This criterion is linked to a Learning Outcome
Regressions20.0 pts
ExcellentSummary output for both types of cars done. No errors and results clear.15.0 pts
Above AvgTwo sets of regressions done but with some minor errors.10.0 pts
AverageOnly one regression done or one significant error made.5.0 pts
Below AvgOne regression done with several major errors present.0.0 pts
PoorRegressions not done or project plagiarized.20.0 pts
This criterion is linked to a Learning Outcome
Calculations15.0 pts
ExcellentForecast, correlation coefficient, and coefficient of determination all done and correct.12.0 pts
Above AvgAll calculations done but with minor errors.9.0 pts
AverageOne calculation missing or substantive error present.5.0 pts
Below AvgTwo calculations missing or other major errors present.0.0 pts
PoorCalculations not done, answers provided without formulas shown, or project plagiarized.15.0 pts
This criterion is linked to a Learning Outcome
Explanations20.0 pts
ExcellentSubstantive answers for all four questions asked.15.0 pts
Above AvgAll questions answered but one lacking substance.10.0 pts
AverageAnswers missing for one question or answers not sufficiently substantive for two questions.5.0 pts
Below AvgMultiple questions unanswered or answers not substantive.0.0 pts
PoorNo explanation provided or answers plagiarized.20.0 pts
Total Points:
100.0
Looking for a similar assignment? Our writers will offer you original work free from plagiarism. We follow the assignment instructions to the letter and always deliver on time. Be assured of a quality paper that will raise your grade. Order now and Get a 15% Discount! Use Coupon Code "Newclient"
![](https://proficientwritershub.com/wp-content/uploads/2019/10/order-now.png)