Using the attached dataset, complete the following tasks:
- Provide a thorough overview of each variable, along with possible values, any irregularities between values, and notes about formatting
- Write a robust list of questions and ideas about the dataset
- Tell 2 stories with a high level of detail, using certain rows in the dataset as the facts.
- Create 4 new columns correctly: Model – adj, Miles per year, Price difference, Vehicle Type
The data comes from a Kaggle competition, and you can read more about it here: https://www.kaggle.com/c/DontGetKicked. Essentially, the data consists of cars that were sold at auction, usually to Used Car dealerships. All of the variables other than "IsBadBuy" were captured at the moment of sale. Dealers would know the make/model/mileage/etc and use that information to make a bid. "VehCost" is what the winning bid was. The "IsBadBuy" variable was added later according to some logic that determined whether the car turned out to have some major issues. We don’t know exactly what the issues were, or how extensive, but they were enough to receive the flag (IsBadBuy = 1 means "Yes, it was a bad buy"; Only cars with a value of 1 are "kicked"). This boolean variable is equivalent to the Survived variable on the Titanic dataset, and we will do a lot of analysis on this in Weeks 4 and 5. It’s what we call a "target variable" in predictive modeling (also "response variable") — basically, it’s what we’ll be trying to predict. That is, can we use all of the other values in a row to predict the IsBadBuy value, and how accurate are our predictions? (we won’t be making any predictions in this class, but we will explore how other variables affect the IsBadBuy variable).
Remember to submit your excel document as .xlsx! And that both your word document and excel document contain your last name. Lastly, do not collaborate on this assignment. This assignment is treated as an individual assessment of your understanding of class concepts but it is open book.
https://learn-us-east-1-prod-fleet02-xythos.content.blackboardcdn.com/5deadc6d1e61f/7572583?X-Blackboard-Expiration=1642928400000&X-Blackboard-Signature=4MxChKGXlTvOWWOiMgPv%2F1064y02OBncS555g26Rnq8%3D&X-Blackboard-Client-Id=100905&response-cache-control=private%2C%20max-age%3D21600&response-content-disposition=inline%3B%20filename%2A%3DUTF-8%27%27Carvana_Data_Dictionary.txt&response-content-type=text%2Fplain&X-Amz-Security-Token=IQoJb3JpZ2luX2VjECsaCXVzLWVhc3QtMSJHMEUCICFWUhgkoBakAJVWL5WRCMBMQ7fNIFnB8I0QOvUf74LJAiEAkmBJEYEC0COsrrwcz2tDYv%2FXp0K7VFATR2HYhS1F5WEq%2BgMIVBACGgw2MzU1Njc5MjQxODMiDP4HBz0yJgWJkmDQsSrXA79QjmxxmbDezCw2trBcVU6eGjEYuuB%2BSlczgpVa6WwB6HMKDbXMitp%2Bh%2BFpye%2BSRv1ZfCJ63brf4OLdfq3s9zx1WkF37D2G6PyZdo%2BqYz1bVAJvF9L8Y3SM5scud9EGXVH9gaw%2FKFcL%2F0qi7NKNdybQ8Mb1Exy8q1nWGWG22itu5V9WCx8PWO35bi4JrIq1xQ2FYaDERqxzDsgfZ1QN5JqzGa2UNxTFhBq5mYF37fqFUpsBZR5D9riAs8aA94qAH%2FdnVv4Pw4quRqfSN1nyaPsiC1UXWeC62i7xC%2FVh6gg%2BYVlnpNcvE1XunARtbsNkJ0Es%2Fq7FRxILZiAhUnUwiWLl4BEcCXNd3ZJqurkOFjupWwYukorEC15mG4xMK3tcWP8HNzDjvJoO%2FpkquUmtuxcAK1%2FBx6T4NIj5SJO2MCa7c%2FaOcdJXoEb8cFn9kJqGX3xL2jV1gic4Zpci3v2xYUSWGjX06%2BQxuS4GLBY3u5gylraTVeK0sqg%2BLUZJLShB0Ll8FN8gR2LkT42tkfpBRQrl2UWFpCduZw4SlzQZpz1lGEPyosv5Poo8bhaKoXHSgOkMITKCmWGKgMJd%2BBSrPNPOAlkjf%2B0kIdO4hl3hV4qoP%2BuN81tiazC5%2F7KPBjqlAckJAf3FWcfFqkMdmcq401f3mkEFRPw12SqbKMI%2BMFDAlrP3OYP72xwINVNPoLEQXmhqiRO55B2ppjCTQGVFrbGtzOQhGLWXac3lkvx96FGcxmmCD02cAXhFZcd0yMz6St%2BAnZbiynu0TiZkYiQzPNovY0q4Jp5lBRyGGIpJY1C1xy%2FEAROb2AJ%2FtPN8CZvj%2B%2B5JYKGGP2M2B7pdaDQpe%2BSuHR%2FiiA%3D%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20220123T030000Z&X-Amz-SignedHeaders=host&X-Amz-Expires=21600&X-Amz-Credential=ASIAZH6WM4PL3OYVVVGS%2F20220123%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=1349dc74cee4a249c95702385ef20089b75ef5b324415275b2df2fbf21d64185
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"
