What is the make and model of the most expensive car

Assignment Help Basic Computer Science

Reference no: EM133408827

Assignment:

Please see the above data set for information

What is the make and model of the most expensive car? What is the make and model of the cheapest car? (Hint: By far the easiest way is to sort the price column and examine the first row and last row. However, for practice, I suggest you use the max and min function in combination with a VLookup. This will be good practice for the exam.)

Run the descriptive statistics on the price variable and report the results. This is through the Data Analysis Tool Pack.

Is the mean and median close to one another? If not, what does that tell us? Display the histogram (using bins of your choosing). Use the histogram and the term skewness and kurtosis to provide evidence in your answer.

What is the correlation between car price and mileage? Is this high or low correlation? What does the correlation tell us in terms of the data?

Should you run correlation between leather and price? If yes, what is the correlation and explain the correlation in terms of the data. If you cannot run the correlation, tell me why.

Reference no: EM133408827

Questions Cloud

Define the rsa algorithem : Define the RSA algorithem briefly. Write all the formula for the RSA algorithm for public key and private key.

Why signed numbers are important in computer : How can we convert any of the number system types to other? What are the complements in Math? Why signed numbers are important in Computer?

Write a functional program : You were asked to write a functional program. How will you write a program to find the factorial of a positive integer number x, using C programming?

Create a heat map of the correlation matrix : "Create a" heat map of the correlation matrix that shows correlation coefficients among all the variables in the dataset. What are your observations?

What is the make and model of the most expensive car : What is the make and model of the most expensive car? What is the make and model of the cheapest car?

Write pseudocode for recursive version of insertion sort : Write pseudocode for this recursive version of insertion sort. Give a recurrence for its worst-case running time.

What kind of interest rate are borrowers paying : What kind of interest rate are borrowers paying? How long are the loan terms? How much are people borrowing?

Research the company record in the area of csr : Research the company's record in the area of CSR. Be sure to look at both their domestic and well as international reputation.

Role of simd processors in solving scientific problems : Discuss the role of different SIMD processors in solving scientific problems. Give the reasons to choose SIMD over MIMD.

User Account

All Pages