Week 2 Data Set<\/a>.<\/p>\nCreate<\/strong> and <\/strong>calculate<\/strong> the following in Excel\u00ae<\/sup>:<\/p>\n\n- Create <\/strong>a Pie Chart which summarizes colors of the cars in the sample.<\/li>\n
- Create <\/strong>a Bar Chart which summarizes the frequency of the models of the cars in the sample.<\/li>\n
- Create a Frequency Table for classes of MPG, including Frequency and Relative Frequency for the cars in the sample.\n
\n- Calculate <\/strong>the mean Days in Inventory for the cars in the sample. <\/li>\n
- Compare <\/strong>that to the median and the mode. <\/li>\n<\/ul>\n<\/li>\n
- Highlight <\/strong>the value that would be a better representation of the “typical” price of a car in inventory?<\/li>\n
- Calculate <\/strong>the standard deviation of the Days in Inventory for the cars in the sample. <\/li>\n
- Calculate <\/strong>the 5 number summary for the suggested retail prices of the cars in the sample. This consists of the 1st, 2nd, 3rd, 4th quartile and the IQR.<\/li>\n<\/ol>\n
\n- Create <\/strong>a Pie Chart which summarizes colors of the cars in the sample.<\/li>\n
- Create <\/strong>a Bar Chart which summarizes the frequency of the models of the cars in the sample.<\/li>\n
- Create a Frequency Table for classes of MPG, including Frequency and Relative Frequency for the cars in the sample.\n
\n- Calculate <\/strong>the mean Days in Inventory for the cars in the sample. <\/li>\n
- Compare <\/strong>that to the median and the mode. <\/li>\n<\/ul>\n<\/li>\n
- Highlight <\/strong>the value that would be a better representation of the “typical” price of a car in inventory?<\/li>\n
- Calculate <\/strong>the standard deviation of the Days in Inventory for the cars in the sample. <\/li>\n
- Calculate <\/strong>the 5 number summary for the suggested retail prices of the cars in the sample. This consists of the 1st, 2nd, 3rd, 4th quartile and the IQR.<\/li>\n<\/ol>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
You manage the inventory for a car dealership. Your management would like you to review current inventory on the dealership lot. Review the Week 2 Data Set. You manage the inventory for a car dealership. Your management would like you to review current inventory on the dealership lot. Review the Week 2 Data Set. Create […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_joinchat":[]},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/172207"}],"collection":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/comments?post=172207"}],"version-history":[{"count":0,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/172207\/revisions"}],"wp:attachment":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/media?parent=172207"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/categories?post=172207"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/tags?post=172207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}