computer model

HOMEWORK

Instructions:Please complete 5 of the following problems. Although some may seem relatively

simple,you should model the musing a spreadsheet. Remember to use good design principles when developing your computer model. 

1.  Shownbelow arethetop20companiesinthe computerindustryby salesaccordingto netvalley.cominarecentyear.CompanySales ($millions)

IBM                                    91,134

HewlettPackard86,696

VerizonCommunications75,112

Dell49,205

Microsoft39,788

Intel38,826

Motorola36,843

Sprint34,680

Canon34,222

Ingram Micro28,808

CiscoSystems24,801

EDS19,757

Xerox15,701

ComputerSciences14,059

Apple13,931

TexasInstruments13,392

Oracle11,799

Sanmina-SCI11,735

Arrow Electronics11,164

SunMicrosystems11,070

Computethemean,median,P30,P60,P90,Q1,Q3,range,andinterquartilerangeonthese data.

2.   ShownherearetheU.S.oilrefinerieswiththelargestcapacityintermsofbarrelsperday accordingtotheU.S.EnergyInformationAdministration.Usetheseas populationdataand answerthequestions. 

Philadelphia,PennsylvaniaSunoco335,000

Pascagoula,MississippiChevron330,000

DeerPark,Texaspartnership329,800

WoodRiver,IllinoisWRB306,000

Port Arthur,TexasPremcor289,000

a. Whatarethevaluesofthemeanandthemedian?Comparetheanswersandstatewhich

youpreferasameasureoflocationforthese dataand why.

b. What are thevaluesof therangeandinterquartilerange?How dothey differ?

c. What are thevaluesofvarianceandstandarddeviation forthesedata?

3.  The  radio  music  listener  market  is   diverse.  Listener   formats  might  includeadult contemporary, albumrock, top40, oldies,rap, country andwestern, classical,andjazz. In targetingaudiences,marketresearchersneed tobeconcernedabouttheagesofthe listenersattractedtoparticularformats.Supposeamarketresearchersurveyedasampleof

170listeners ofcountrymusic radiostations andobtainedthefollowingage distribution. Age                                     Frequency

15–under20                            9

20–under25                          16

25–under3027

30–under35                          44

35–under40                          42

40–under45                          23

45–under50                            7

50–under55                            2

a.   Createahistogramusingthe binnedvaluesprovided.

b.   What are themeanandmodalagesofcountry music listeners?

c.   What are thevarianceandstandard deviationof theagesofcountry music listeners?

4.  Dataon theprevalenceofprostatecarcinomabyagerangewerecollected. (a) Constructa relativefrequency histogramforthedatalisted in thefollowingtable.(b) estimate theage atwhich 50% ofmencouldbeexpectedtohave prostatecancer

AgeGroup

90–99PercentwithDisease

61.3

80–8938.0

70–7929.8

60–6920.5

50–5911.8

40–496.9

30–392.1

5.  Thetablebelow givesdatacollected fromthestudents attendinganelementarystatistics courseat theUniversityofWisconsin. Thesedataincludesex,height,numberofyearsin college,andthegeneralareaofintendedmajor[Humanities(H); SocialScience(S); BiologicalScience(B); PhysicalScience(P)].

ClassData

Student    Height YearinIntended         Student           Height YearinIntended

No.            Sex      InchesCollege Major              No.     Sex      InchesCollegeMajor

1F673S26M671B

2M723P27M683P

3M704S28M724B

4M701B29F683P

5F614P30F662B

6F663B31F652B

7M713H32M644B

8M674B33M721H

9M653S34M674B

10F673B35M733S

11M743H36F714B

12M683S37M713B

13M742P38M692S

14F644P39F694P

15M693S40M744S

16M643B41M733B

17M724P42M683B

18M713B43F662S

19F672S44M732P

20M704S45M732S

21M664S46M674S

22F672B47F623S

23M684S48M682B

24M713H49M713S

25M751S

a)  Sort databyYearinCollegeandcreateareport of Descriptivedatafortheothervariables

(tip:someof thesearenon-numeric)

b) Sort databy Intended Majorandcreateareport of Descriptivedatafortheothervariables 

6.  Thefollowingtableshows theageat inauguration of eachU.S.president.

Ageat

NameInauguration

1.  Washington 57

2.   J.Adams61

3.   Jefferson57

4.   Madison 57

5.   Monroe58

6.   J. Q.Adams57

7.   Jackson61

8.   Van Buren54

9.   W. H. Harrison68

10. Tyler51

11. Polk 49

12. Taylor64

13. Fillmore50

14. Pierce48

15. Buchanan65

16. Lincoln 52

17. A. Johnson56

18. Grant 46

19. Hayes 54

20. Garfield 49

21. Arthur50

22. Cleveland47

23. B. Harrison55

24. Cleveland55

25.  McKinley54

26. T.Roosevelt42

27. Taft51

28. Wilson 56

29. Harding55

30. Coolidge51

31. Hoover54

32. F. D. Roosevelt 51

33. Truman60

34. Eisenhower62

35. Kennedy43

36. L. Johnson55

37.  Nixon 56

38. Ford 61

39. Carter52

40. Reagan 69 

41. G. Bush64

42. Clinton46

43. G.W. Bush54

44. Obama47

a)  Findthemean,median,mode,andstandard deviation

b) Addacolumntothespreadsheet andidentify whichquartileeachisin withrespecttoage. c)  Createahistogramtoshow thedistribution of theirages. Isthisskewed?