Question Details

(solution) I am having trouble with these 3 questions, i need help


I am having trouble with these 3 questions, i need help understanding what to do. Thank you buddy

Predict the average price of an automatic hatchback which weighs 1100 kg with 97 kW of power that uses 6.7 L per 100 km of fuel if it is appropriate to do so.  Show the predicted regression equation. 

Do the results suggest that the data satisfy the assumptions of a linear regression: Linearity, Normality of the Errors, and Homoscedasticity of Errors?  Show using scatter diagrams, normal probability plots and/or histograms and Explain

Would these results tell us anything about the population distribution of vehicles on the road?  If not, describe a scenario in how you would construct a sample to sample vehicles on the road. 

This is the excel sheet that comes with these questions


Thank you




Make

 

Audi

 

Audi

 

Audi

 

BMW

 

BMW

 

Ford

 

Ford

 

Ford

 

Holden

 

Holden

 

Holden

 

Holden

 

Hyundai

 

Hyundai

 

Hyundai

 

Kia

 

Kia

 

Kia

 

Mazda

 

Mazda

 

Mazda

 

Mitsubishi

 

Mitsubishi

 

Mitsubishi

 

Nissan

 

Nissan

 

Nissan

 

Subaru

 

Subaru

 

Volkswagen

 

Volkswagen

 

Volkswagen

 

Mercedes

 

Mercedes

 

Mercedes Model

 

Price

 

Power

 

A4

 

74440

 

S3

 

84990

 

S3

 

71061

 

Z4

 

90296

 

535i

 

130180

 

Fiesta

 

27880

 

Territory

 

41924

 

Falcon XR8

 

53888

 

Barina

 

16490

 

Trax

 

23540

 

Cruze

 

22990

 

Commodore SV6

 

38540

 

Accent

 

15970

 

Tucson

 

28990

 

Elantra

 

27566

 

Picanto

 

15510

 

Cerato

 

23982

 

Rio

 

17510

 

CX-5

 

31081

 

MX-5

 

35770

 

3

 

33685

 

Lancer

 

23489

 

ASX

 

25750

 

Lancer GSR

 

26951

 

370Z

 

76686

 

Pathfinder

 

73864

 

Pulsar

 

33021

 

Impreza

 

24990

 

WRX STI

 

58990

 

Tiguan

 

39490

 

Golf

 

39890

 

Jetta

 

39206

 

A250

 

59865

 

CLS400

 

153783

 

SLK300

 

112981 140

 

210

 

210

 

135

 

225

 

134

 

195

 

335

 

85

 

103

 

104

 

210

 

74

 

114

 

112

 

63

 

110

 

79

 

114

 

96

 

138

 

110

 

110

 

125

 

245

 

190

 

140

 

110

 

221

 

132

 

110

 

118

 

160

 

245

 

180 Kerb Weight Fuel

 

1585

 

1695

 

1505

 

1395

 

1645

 

1197

 

1963

 

1822

 

1193

 

1375

 

1374

 

1643

 

1140

 

1556

 

1355

 

885

 

1287

 

1221

 

1455

 

1009

 

1357

 

1325

 

1335

 

1325

 

1544

 

2065

 

1340

 

1335

 

1537

 

1626

 

1265

 

1335

 

1505

 

1775

 

1487 5.3

 

7.1

 

7

 

6.8

 

7.9

 

6.2

 

10.5

 

13.7

 

6.9

 

7.9

 

7.4

 

9

 

6.2

 

7.9

 

7.2

 

5.3

 

6.6

 

5.7

 

6.4

 

6.1

 

6.1

 

7.3

 

7.6

 

8.7

 

10.9

 

10.2

 

7.8

 

6.8

 

10.4

 

8.8

 

5.4

 

6.2

 

6.7

 

7.8

 

6.3 Automatic Hatchback

 

1

 

0

 

1

 

0

 

0

 

0

 

0

 

0

 

1

 

0

 

0

 

1

 

1

 

0

 

1

 

0

 

0

 

1

 

1

 

0

 

1

 

0

 

0

 

0

 

1

 

1

 

1

 

0

 

1

 

0

 

1

 

1

 

0

 

0

 

0

 

1

 

0

 

0

 

0

 

0

 

1

 

1

 

1

 

0

 

0

 

0

 

0

 

0

 

1

 

0

 

1

 

0

 

1

 

1

 

1

 

0

 

0

 

0

 

1

 

0

 

1

 

1

 

1

 

0

 

1

 

1

 

1

 

0

 

1

 

0 Sedan SUV

 

1

 

0

 

1

 

0

 

1

 

0

 

0

 

1

 

0

 

0

 

1

 

1

 

0

 

0

 

1

 

0

 

1

 

0

 

0

 

0

 

0

 

1

 

0

 

1

 

0

 

0

 

0

 

1

 

1

 

0

 

0

 

1

 

0

 

1

 

0 0

 

0

 

0

 

0

 

0

 

0

 

1

 

0

 

0

 

1

 

0

 

0

 

0

 

1

 

0

 

0

 

0

 

0

 

1

 

0

 

0

 

0

 

1

 

0

 

0

 

1

 

0

 

0

 

0

 

1

 

0

 

0

 

0

 

0

 

0 Convertible

 

0

 

1

 

0

 

1

 

0

 

0

 

0

 

0

 

0

 

0

 

0

 

0

 

0

 

0

 

0

 

0

 

0

 

0

 

0

 

1

 

0

 

0

 

0

 

0

 

1

 

0

 

0

 

0

 

0

 

0

 

0

 

0

 

0

 

0

 

1

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Jan 30, 2021

PRICE: $15

Solution~0001017775.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Jan 30, 2021

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.

Order Now