Need bussiness stats help

here is the question

Assignment Week 2

Question 1

1.

 

Baseball stadiums vary in age, style, size, and in many other ways. Fans might think of the size of the stadium in terms of the number of seats; while the player might measure the size of the stadium by the distance from the homplate to the centerfield fence. Note:

CF

= distance from homeplate to centerfield fence.

Using the Excel add-in construct your scatter diagram with the data set provide below.
 

 

 

400

 

400

 

400

 

400

 

 

400

 

400

 

 

 

 

400

 

 

400

 

 

 

405

 

 

404

 

 

400

 

400

 

404

 

 

 

400

 

 

408

 

408

Seats		CF
38805																															420
41118												400
56000
45030
3 407 7
40793
56144			408
50516
406 15
48190	406
36331	434
43 405		405
48911
50449	415
50091
43772			404
49033	407
47447
401 20	422
41503
40950	435
38496
41900
42271
43647	401
42600	396
46200
41222	403
52355
45000

 

Is there a relationship between these two measurements for the “size” of the 30 Major League Baseball stadiums?

a. Before you run your scatter diagram answer the following: What do you think you will find? Bigger fields have more seats? Smaller fields have more seats? No relationship exists between field size and number of seats? A strong relationship exists between field size and number of seats? Explain.

b. Construct a scatter diagram and include it in your answer.

c. Describe what the scatter diagram tells you, including a reaction to your answer in (a).

Question 2

2. Place a pair of dice in a cup, shake and dump them out. Observe the sum of dots. Record 2, 3, 4, _ , 12. Repeat the process 25 times. Using your results, find the relative frequency for each of the values: 2, 3, 4, 5, _ , 12.