In my Spring 2022 semester, I completed a project in my Intermediate Business Statistics course (MAS202) in which I used Microsoft Excel to analyze a dataset that contains information for 20 family sedans, including price, cost-per-mile, road-test scores, and predicted reliability. Consumer Reports developed what is known as a value score, which takes these predictor variables into account to determine the value of a given car. Through calculating the descriptive statistics, p-values, t-statistics, and R-squares of each variable, we discovered that price and cost-per-mile had the most influence over value and should be included in building a new model for finding value scores. Click here for the written report and here for the slide deck!
-
Notifications
You must be signed in to change notification settings - Fork 0
icg42/finding-best-car-value
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
About
Data analysis using Microsoft Excel. Check out this repository's README for more info!
Topics
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published