( Especially I would like to know the step by step how to do the 3rd question on JMP if possible) Thank you!

The U.S. Department of Energy's Fuel Economy Guide provides fuel efficiency data for cars and trucks. A portion of the data for 225 compact, midsized, and large cars follows. The Class column identifies the size of the car; Compact, Midsize, or Large. The Displacement column shows the engine's displacement in liters. The FuelType column shows whether the car uses premium (P) or regular (R) fuel, and the HwyMPG column shows the fuel efficiency rating for highway driving in terms of miles per gallon. The complete data set is contained in the fileFuelData-225.xlsx.:

1.Develop the estimated regression equation that can be used to predict the fuel efficiency for highway driving given the engine's displacement, the dummy variables Class Midsize and Class Large, and the dummy variable Fuel Premium.

2.How much of the variation in the sample values of HwyMPG does this estimated regression equation explain?

3.(The value of Class Midsize is 1 if the car is a midsize car and 0 otherwise; the value of Class Large is 1 if the car is a large car and 0 otherwise. Thus, for a compact car, the value of Class Midsize and the value of Class Large are both 0. The value of Fuel Premium is 1 if the car uses premium fuel and 0 if the car uses regular fuel.)

4.For the estimated regression equation developed in part a, check for the significance of an overall regression relationship and relationships between each of the independent variables and the dependent variable using the 0.05 level of significance.

I'm not sure how to send the Data file, but I'll just copy/paste here:

Car:

1

2

3

4

6

7

8

9

10

13

14

15

16

17

18

19

20

22

23

29

30

31

33

36

37

39

40

44

45

46

47

48

49

50

53

54

56

59

60

62

63

64

67

68

69

70

71

72

73

74

75

78

84

85

87

89

90

91

93

96

97

99

100

101

102

103

104

106

107

108

110

112

113

114

115

116

117

118

121

122

123

124

125

126

127

130

131

132

134

136

137

138

140

142

143

144

146

147

149

150

151

152

153

155

156

158

159

160

161

163

167

168

169

170

171

172

174

177

179

180

181

185

186

187

188

189

191

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

211

212

213

214

215

216

217

218

219

220

221

222

224

225

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

251

252

253

255

256

257

258

259

261

262

263

264

267

268

269

271

272

273

275

276

277

278

280

281

282

283

284

285

288

289

290

291

293

295

298

300

302

303

304

306

308

309

310

311

Class:

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Compact

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Midsize

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Large

Displacement:

3.1

3.1

3

3

3

2.4

3.5

3

2.4

3

2.5

2.4

5.3

6

3.5

3.5

3.5

3.5

3.8

4.2

4.6

4.6

3.5

3.2

3.5

3.5

3.5

4.8

3.5

4.6

4.6

5.7

5.7

4.6

4.2

4.8

3

3.9

3.5

4.2

4.6

4.6

5.7

3.5

4.8

3

4.2

5

3.5

5.5

4.2

4.5

4.5

5.5

5.2

4.4

5.5

6.2

6.2

4.6

4.6

5.5

5.5

6.2

6

5.5

5

5.5

6

5.5

5.7

1.8

2

1.6

1.8

1.6

2.4

2

2

1.8

2.5

2

1.6

1.6

1.6

2

1.8

2.5

2

2

2

2.4

2.4

2.4

2.2

2.4

2.5

1.8

2.4

2.4

2

2.4

2.4

2.4

2.4

2.4

2

2.5

2.4

2

2.3

2.3

2

2

3.5

2.5

2.5

3.5

2.5

2

3.5

2.3

2.3

3.5

2.4

2.4

3

2.5

2.5

2.4

2.4

2.4

2.4

3.5

2

2

2

2

3.9

3.5

3.3

3.5

3.5

3

2

3.8

3.5

2.3

2.7

2.3

3.5

2.3

3.8

3.5

2

3.1

2.5

2.5

2.5

2.5

2.5

2.5

3.3

3.5

3.1

3

3.5

3.5

3.5

2.7

2.7

2.7

2

2.7

2.4

3

3

3.6

3

3

3

2.8

2.5

2.5

2.4

2.4

2.4

3.5

3.6

2.7

2.7

3.8

3.3

3

3

3

3.5

2.3

3.6

3.6

3.6

3.6

3.6

3.5

3.5

3

3.5

2.5

2.5

3.5

4.2

4.2

4.2

3.1

3

3.5

3.8

5.3

3.6

3.6

3.6

3

3

3

3

Fuel Type:

P

P

P

P

P

P

P

P

P

P

P

R

P

P

R

R

R

R

R

P

P

P

P

P

R

R

R

P

P

R

R

R

R

R

P

P

P

R

P

P

R

R

R

R

P

P

P

P

P

P

P

P

P

P

P

P

P

P

P

R

R

P

P

P

P

P

P

P

P

P

P

R

R

R

R

R

R

R

R

R

R

R

R

R

R

R

R

R

P

R

R

R

R

R

R

R

R

R

R

R

P

R

R

R

R

R

R

R

R

P

R

R

R

R

R

R

R

R

P

P

R

R

R

R

P

P

P

P

P

P

P

P

P

R

R

R

R

R

R

R

R

R

R

P

P

R

R

R

R

R

R

R

R

R

P

P

P

P

R

R

R

R

R

P

P

P

P

P

P

R

R

R

R

R

R

R

R

R

P

P

P

P

P

P

P

P

R

R

R

R

R

R

R

P

P

P

P

P

P

R

R

R

R

R

R

P

P

P

P

R

P

P

P

P

P

P

P

P

R

R

R

R

R

R

R

Hwy MPG:

25

25

25

25

25

25

25

25

24

24

24

24

24

24

24

24

24

24

24

24

24

24

24

24

24

24

24

23

23

23

23

23

23

23

23

23

23

22

22

22

22

22

22

22

22

22

22

22

22

22

21

21

20

20

19

19

19

19

18

18

18

17

17

17

17

17

17

16

16

16

16

37

35

35

35

34

34

33

33

33

33

33

32

32

32

32

32

32

31

31

31

31

31

31

31

31

31

31

31

31

30

30

30

30

30

30

30

30

30

29

29

29

29

29

29

29

29

29

29

29

29

29

29

29

28

28

28

28

28

28

28

28

28

28

28

28

28

28

28

28

28

28

28

28

28

28

28

28

28

28

28

28

28

28

27

27

27

27

27

27

27

27

27

27

27

27

27

27

27

27

27

27

27

27

27

26

26

26

26

26

26

26

26

26

26

26

26

26

26

26

26

26

26

26

26

26

26

26

26

26

26

26

26

26

26

25

25

25

25

25

25

25

25

25

25

25

25

25

25

25

25

25

25

25

25