Final Assignment
Download the file 2004Cars.xlsx from the Final Assignment folder on D2L. This file contains information about different vehicles. I also posted the file 2004Cars-Codebook for information regarding the variables on the Excel file. You need to submit your Excel file that contains your works and the graph, as well as a Word document file with your written answers (alternatively you can write your answers as text on the Excel file too, but make sure it is visible to me). Do your work regarding each question on the worksheet labeled by the question number. I need to see how you found the answers in your Excel file.
1) Find the market shares for different types of cars: Sports, Sports Utility, Wagon, Minivan, Pickups. Show it on a pie chart.
2) To explore the effect of Horsepower and the number of cylinders, separate the data into two groups; 4-cylinder cars and above 4-cylinder cars. Then find the average horsepower for those two groups of cars. Evaluate if the two groups of cars have equal average horsepower. To evaluate you need to do two things here. First, find the correlation between the Horsepower and the number of cylinders. Then use a t-test to test if those two groups of cars have the equal horsepower. Write down all the steps needed to do the test.
3) Calculate the expected profit for each car by subtracting the dealer cost from the suggested retail price. Find the average profits for all five types of cars: Sports, Sports Utility, Wagon, Minivan, and Pickup. What strategy would you recommend regarding which types of cars they should focus more to sell?
4) Separate the cars based on their weights. You decide what weight to be used as the reference for the separation. Evaluate which cars are more costly to make, Cars with higher weights or cars with lower weights. (Here, you should do three things here: find the correlation between the weight and the costs, then separate data into two groups based on the weights and calculate the average costs for the two groups, and at the end perform a t-test to see if there is a significant difference in the costs based on weights.)
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
