Quantative methods for business Assignment | Professional Writing Services

BUS 209 – Project 2

Name:                                                                                     Due: 31 May 2020 by 5.00 PM

Don't use plagiarized sources. Get Your Custom Essay on
Quantative methods for business Assignment | Professional Writing Services
Just from $13/Page
Order Essay

Assume that the Coronavirus economic impact is likely to change peoples’ preferences for cars.  Rather than the brand and country of origin, if people chose to pay attention to the characteristics of the cars, what are the things that they will consider important in peoples’ decision? You have been asked to assess the characteristics of cars that are important for the manufacturers. Manufacturers are interested on knowing what characteristics of cars that bring them higher value.  The posted Excel file (Project data 2) is Moodle is the data for prices of cars and associated characteristics cars.

  1. If you chose to buy a car, what characteristics would you consider are important for you? (5 points)
  2. What do you mean by covariance between price of a car and engine horsepower?(10 points)
  3. Based on your preferred car characteristics(in part a) and price of a car, estimate the correlation coefficient and comment on the estimated value.(10 points)
  4. Using the data analysis tool (descriptive statistics) estimate the summary statistics of all the variables (except for manual variable)(15 points)
  5. Price be the dependent variable and other variables as independent variables, state null and alternative hypothesis.(10 points)
  6. Estimate regression model using Excel analysis and comment on; (20 points)
  7. Goodness of the model (5 points)
  8. Significant of coefficients (10 points)
  • Interpret the coefficient (15 points)
  1. Predict the price of a manual car based on mean values of all the other variables.(10 points)
  2. Write minimum of 150 words report to the management (manufacturer) on automobile demand and automobile characteristics. (25 points)

 

 

 

 

Manufacturer Price Highway_MPG AirBags Number_of_cylinders Engine_size Horsepower Manual Fuel_Tank_Capacity Passenger_Capacity
Acura 15,900 31 0 4 2 140 1 13 5
Acura 33,900 25 2 6 3 200 1 18 5
Buick 15,700 31 1 4 2 110 0 16 6
Buick 20,800 28 1 6 4 170 0 18 6
Buick 23,700 25 1 6 6 180 0 23 6
Buick 26,300 27 1 6 4 170 0 19 5
Cadillac 40,100 25 2 8 5 295 0 20 5
Chevrolet 13,400 36 0 4 2 110 1 15 5
Chevrolet 15,900 29 0 4 2 110 0 17 6
Chevrolet 16,300 23 0 6 4 170 0 20 7
Chevrolet 38,000 25 1 8 6 300 1 20 2
Dodge 9,200 33 0 4 2 92 1 13 5
Dodge 11,300 29 1 4 2 93 1 14 5
Dodge 13,300 27 1 4 3 100 1 16 6
Dodge 19,000 21 1 6 3 142 0 20 7
Dodge 15,600 27 1 4 3 100 0 16 6
Eagle 12,200 33 0 4 2 92 1 13 5
Ford 7,400 33 0 4 1 63 1 10 4
Ford 10,100 30 0 4 2 127 1 13 5
Ford 11,300 27 0 4 2 96 1 16 5
Ford 15,900 29 1 4 2 105 1 15 4
Ford 14,000 30 1 4 2 115 1 16 4
Ford 19,900 20 1 6 3 145 1 21 7
Ford 20,200 30 1 6 3 140 0 16 5
Geo 12,500 36 1 4 2 90 1 12 4
Honda 12,100 46 1 4 2 102 1 12 4
Hyundai 8,000 33 0 4 2 81 1 12 5
Hyundai 10,000 29 0 4 2 124 1 14 5
Hyundai 10,000 34 0 4 2 92 1 12 4
Hyundai 13,900 27 0 4 2 128 1 17 5
Lexus 28,000 24 1 6 3 185 1 19 5
Lexus 35,200 23 2 6 3 225 1 21 4
Mazda 8,300 37 0 4 2 82 1 13 4
Mazda 11,600 36 0 4 2 103 1 15 5
Mazda 16,500 34 1 4 3 164 1 16 5
Mazda 19,100 24 0 6 3 155 0 20 7
Mercury 14,100 26 1 4 2 100 1 11 4
Mercury 14,900 26 0 6 4 140 0 18 5
Mitsubishi 10,300 33 0 4 2 92 1 13 5
Mitsubishi 26,100 24 1 6 3 202 0 19 5
Nissan 11,800 33 1 4 2 110 1 13 5
Nissan 15,700 30 1 4 2 150 1 16 5
Nissan 19,100 23 0 6 3 151 0 20 7
Nissan 21,500 26 1 6 3 160 0 19 5
Oldsmobile 13,500 31 0 4 2 155 0 15 5
Oldsmobile 16,300 31 1 4 2 110 0 17 5
Oldsmobile 19,500 23 0 6 4 170 0 20 7
Oldsmobile 20,700 28 1 6 4 170 0 18 6
Plymouth 14,400 30 0 4 2 92 1 16 4
Pontiac 9,000 41 0 4 2 74 1 13 4
Pontiac 11,100 31 0 4 2 110 1 15 5
Pontiac 24,400 28 2 6 4 170 0 18 6
Saturn 11,100 38 1 4 2 85 1 13 5
Subaru 8,400 37 0 3 1 73 1 9 4
Subaru 10,900 30 0 4 2 90 1 16 5
Subaru 19,500 30 1 4 2 130 1 16 5
Suzuki 8,600 43 0 3 1 70 1 11 4
Toyota 9,800 37 1 4 2 82 1 12 5
Toyota 18,400 32 1 4 2 135 1 16 4
Toyota 18,200 29 1 4 2 130 1 19 5
Toyota 22,700 22 1 4 2 138 1 20 7
Volkswagen 9,100 33 0 4 2 81 1 12 4
Volkswagen 19,700 21 0 5 3 109 1 21 7
Volkswagen 20,000 30 0 4 2 134 1 19 5
Volkswagen 23,300 25 0 6 3 178 1 19 4
Volvo 22,700 28 1 4 2 114 1 16 5
Volvo 26,700 28 2 5 2 168 1 19 5
16,957 30 1 5 3 131 1 16 5

Place Order
Grab A 14% Discount on This Paper
Pages (550 words)
Approximate price: -
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Try it now!

Grab A 14% Discount on This Paper

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.