Chapter 9 case 9.2 | Operations Management homework help

On the tab labeled “Data”, I have provided the calendar year 2000 Presidential voting results from Florida which are associated with Case 9.2 on Pages 481.  Carefully read the case in the textbook and then review the data to familiarize yourself with the given information. 

On the “Case Update” tab, there are five questions.  After performing all necessary work in Excel, please respond to each question.  All written results should be included on the Case Update tab.  Each question is worth 16 points:   8 points for the correct mechanical work within Excel and 8 points for a clear, concise, grammatically correct response to the associated question.  Your responses should be typed in unbolded black font right after the statement of the question. 

Remember, cases are individual work.  Good luck and as always…HAVE FUN!

 

Votes for:

       

COUNTY

Gore

Bush

Buchanan

Total Votes

     

Liberty

1011

1361

39

2411

     

Lafayette

788

1696

10

2494

Text Box:                 Counties won by Bush                  Counties won by Gore

Glades

1441

1804

9

3254

Union

1407

2322

29

3758

Hamilton

1722

2164

23

3909

Franklin

2046

2444

33

4523

Dixie

1826

2679

29

4534

Calhoun

2155

2837

90

5082

     

Gilchrist

1910

3200

29

5139

     

Gulf

2389

3564

71

6024

     

Madison

3011

3083

29

6123

     

Hardee

2341

3746

30

6117

     

Taylor

2647

4015

27

6689

     

Holmes

2154

4958

76

7188

     

De Soto

3322

4265

36

7623

     

Washington

2796

4938

88

7822

     

Hendry

3239

4734

22

7995

     

Baker

2392

5601

73

8066

     

Wakulla

3835

4499

46

8380

     

Bradford

3072

5431

65

8568

     

Okeechobee

4588

5085

43

9716

     

Suwannee

4084

8041

108

12233

     

Levy

5403

6806

67

12276

     

Jackson

6868

9183

102

16153

     

Walton

5637

12761

120

18518

     

Columbia

7047

10946

89

18082

     

Sumtter

9634

12621

114

22369

     

Nassau

6952

16505

90

23547

     

Putnam

12091

13493

147

25731

     

Highlands

14167

20260

127

34554

     

Indian River

19768

28653

105

48526

     

Santa Rosa

12795

36482

311

49588

     

Citrus

25501

29744

270

55515

     

Clay

14630

41745

186

56561

     

Bay

18850

38637

248

57735

     

St. Johns

19482

39497

229

59208

     

Martin

26619

33864

108

60591

     

Charlotte

29641

35419

182

65242

     

Okaloosa

16924

52043

267

69234

     

Lake

36555

49963

289

86807

     

Collier

29905

60426

122

90453

     

Marion

44665

55555

563

100783

     

Manatee

49169

57948

272

107389

     

Escambia

40958

73029

504

114491

     

Seminole

58888

75293

194

134375

     

Sarasota

72854

83400

305

156559

     

Polk

74977

90101

538

165616

     

Lee

73560

106141

305

180006

     

Brevard

97318

115001

570

212889

     

Duval

107680

152020

650

260350

     

Hillsborough

169529

180713

845

351087

     

COUNTY

Bush

Gore

Buchanan

Total Votes

     

Jefferson

2478

3014

29

5521

     

Gadsden

4750

9556

39

14345

     

Flagler

12608

13981

83

26672

     

Monroe

16059

16843

47

32949

     

Osceola

26212

28081

145

54438

     

Hernando

30646

32446

242

63334

     

St. Lucie

34705

41303

124

76132

     

Alachua

34062

47100

262

81424

     

Leon

39053

61130

282

100465

     

Pasco

68582

69264

570

138416

     

Volusia

82214

96163

396

178773

     

Orange

134476

140151

446

275073

     

Pinellas

184884

200312

1010

386206

     

Palm Beach

152846

268905

3407

425158

     

Broward

177279

385618

789

563686

     

Dade

289456

328207

561

618224

     

 

Question 1 (16 Points):  On the Data tab, you will find the results listed by the counties each candidate won during the election (Bush in red and Gore in blue).  Considering only the counties won by Bush, on a new tab labeled “Bush Scatter”, build a scatterplot with Gore totals as the independent variable and Bush totals as the dependent variable.  What is the associated regression equation and goodness of fit measure?

Question 2 (16 Points):  On the Data tab, you will find the results listed by the counties each candidate won during the election (Bush in red and Gore in blue).  Considering only the counties won by Gore, on a new tab labeled “Gore Scatter”, build a scatterplot with Bush totals as the independent variable and Gore totals as the dependent variable.  What is the associated regression equation and goodness of fit measure?

Question 3 (16 Points):  Bush won Brevard County with 115,001 votes.  Using the results in Question 1 above, estimate the total number of votes President Bush should have received given the actual number of votes for Gore.  What is the residual as compared to the actual number of votes won by Bush?

Question 4 (16 Points):  Now we want to estimate the number of votes Buchanan should have received given the votes received by both Bush and Gore in the counties won by each candidate.  On a new tab labeled “Bush Multiple” use both the Bush and Gore totals from the counties won by  Bush as independent variables along with the asociated Buchanan totals as the dependent variable and develop the regression equation.  On a new tab labeled “Gore Multiple” use both the Bush and Gore totals from the counties won by Gore as independent variables along with the asociated Buchanan totals as the dependent variable and develop a second regression equation.  After completing these analyses, which data, either the counties won by Bush or the counties won by Gore, best estimate the number of votes expected for Buchanan.  Clearly state the reasoning behind your choice of data selection. 

Question 5 (16 Points):  Based on the best model you found in Question 4, refer back to the Data tab and note that each candidate has a row where the entries are in white font.  If the best model you found in Question 4 was based off the counties won by Bush, estimate the number of votes Buchanan should have received in Okeechobee County based on the votes received by Bush and Gore.  If the best model you found in Question 4 was based off the counties won by Gore, estimate the number of votes Buchanan should have expected in Palm Beach County based on the votes received by Bush and Gore.  What isthe residual value in the predicted number of votes as compared to the actual number of votes received by Buchanan?

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>