2. Same data. Into box A copy the properly-labeled DAT descriptive statistics output for the data....

Transcribed Image Text:

2. Same data. Into box A copy the properly-labeled DAT descriptive statistics output for the data. Into box B, using bins suggested in the Excel sheet, copy the frequency histogram (not distribution table) for the data. Edit as usual (no gaps, etc.). Chart and axis titles must be descriptive, not generic (don't use bin, frequency, histogram, etc). Poor formatting will hurt your score. Box B: Retain Source Formatting. (6+10= 16 points) Box A: Paste Special/Worksheet Object A B 46 Mutual Funds 12-month total return % Smart Money 2/2004 (a market rebound period) Mutual Fund Alger Capital Appreciation Alger LargeCap Growth. Alger MidCap Growth Alger Small Cap AllianceBernstein Technology Federated American Leaders erated Allen Federated Captial Appreciation Federated Equity-Income Federated Kaufmann Federated Max-Cap Index Federated Stock Janus Adviser Int'l Growth Janus Adviser Worldwide Janus Enterprise Janus High-Yield Janus Mercu Janus Mercury Janur Overras Janus Overseas Janus Worldwide Nations Convertible Secuities Nations Int'l Equity Con Fahd Nations LargeCap Enhd. Core Nations LargeCap Index Motion Mida Nation MidCap Index Nations Small Company: Nations SmallCap Index Nations Strategic Growth Nations Value Inv One Group Diversified Equity One Group Diversified Int'l One Group Diversified Mid Cap One Group Equity Income One Group Int'l Equity Index One Group Large Cap Growth One Group Large Cap Value Group Mid One Group Mid Cap Growth Mid One Group Mid Cap Value One Group Samll Cap Growth CON PBHG Growth Putnam Europe Equity Putnam Int'l Capital Opportunity Putnam International Equity Putnam Int'l New Opportunity Strong Advisor Mid Cap Growth Strong Growth 20 Strong Growth Inv Strong Large Cap Growth C Return 23.5 22.8 38.3 41.3 40.6 15.6 12.4 4617 11.5 33.3 20 16 20 16.9 10.3 3.4 24.2 12.1 20.6 11.0 11.9 A 4.1 ne 13.6 10.7 PAS 13.2 VO 13.5 ... 19.5 21.4 24.5 10.4 10.8 10 10.9 151 15.1 CC 6.6 13.2 136 13.6 PR 12.8 18.7 www 11.4 ne 23.6 M 27.3 20.4 Wax 36.6 2 21.5 26.3 23.7 11.7 23.2 14.5 D E Return % 0 5 10 15 20 200 25 23 30 35 40 45 F G H Part 2 Survey data Music Preferences of a sample of UNO students jazz jazz Bene jazz Jose гар Tup rap Exp rap skup rap string quartets patriotic tunes sea shanties gospel gospel Cornel gospel Gornel gospel Gornal gospel BORNEL gospel P rock rock rock Cu folk CU folk patriotic tunes jazz rap rap M rap rap string quartets strin string quartets www string quartets gospel gospel gospel Stepe gospel gospel L rock rock C rock folk ZAIL folk gospel Boo gospel rock rock rock folk folk 1 J Survey Categories Kind of Music jazz rap string quartets gospel rock folk patriotic tunes sea shanties 2. Same data. Into box A copy the properly-labeled DAT descriptive statistics output for the data. Into box B, using bins suggested in the Excel sheet, copy the frequency histogram (not distribution table) for the data. Edit as usual (no gaps, etc.). Chart and axis titles must be descriptive, not generic (don't use bin, frequency, histogram, etc). Poor formatting will hurt your score. Box B: Retain Source Formatting. (6+10= 16 points) Box A: Paste Special/Worksheet Object A B 46 Mutual Funds 12-month total return % Smart Money 2/2004 (a market rebound period) Mutual Fund Alger Capital Appreciation Alger LargeCap Growth. Alger MidCap Growth Alger Small Cap AllianceBernstein Technology Federated American Leaders erated Allen Federated Captial Appreciation Federated Equity-Income Federated Kaufmann Federated Max-Cap Index Federated Stock Janus Adviser Int'l Growth Janus Adviser Worldwide Janus Enterprise Janus High-Yield Janus Mercu Janus Mercury Janur Overras Janus Overseas Janus Worldwide Nations Convertible Secuities Nations Int'l Equity Con Fahd Nations LargeCap Enhd. Core Nations LargeCap Index Motion Mida Nation MidCap Index Nations Small Company: Nations SmallCap Index Nations Strategic Growth Nations Value Inv One Group Diversified Equity One Group Diversified Int'l One Group Diversified Mid Cap One Group Equity Income One Group Int'l Equity Index One Group Large Cap Growth One Group Large Cap Value Group Mid One Group Mid Cap Growth Mid One Group Mid Cap Value One Group Samll Cap Growth CON PBHG Growth Putnam Europe Equity Putnam Int'l Capital Opportunity Putnam International Equity Putnam Int'l New Opportunity Strong Advisor Mid Cap Growth Strong Growth 20 Strong Growth Inv Strong Large Cap Growth C Return 23.5 22.8 38.3 41.3 40.6 15.6 12.4 4617 11.5 33.3 20 16 20 16.9 10.3 3.4 24.2 12.1 20.6 11.0 11.9 A 4.1 ne 13.6 10.7 PAS 13.2 VO 13.5 ... 19.5 21.4 24.5 10.4 10.8 10 10.9 151 15.1 CC 6.6 13.2 136 13.6 PR 12.8 18.7 www 11.4 ne 23.6 M 27.3 20.4 Wax 36.6 2 21.5 26.3 23.7 11.7 23.2 14.5 D E Return % 0 5 10 15 20 200 25 23 30 35 40 45 F G H Part 2 Survey data Music Preferences of a sample of UNO students jazz jazz Bene jazz Jose гар Tup rap Exp rap skup rap string quartets patriotic tunes sea shanties gospel gospel Cornel gospel Gornel gospel Gornal gospel BORNEL gospel P rock rock rock Cu folk CU folk patriotic tunes jazz rap rap M rap rap string quartets strin string quartets www string quartets gospel gospel gospel Stepe gospel gospel L rock rock C rock folk ZAIL folk gospel Boo gospel rock rock rock folk folk 1 J Survey Categories Kind of Music jazz rap string quartets gospel rock folk patriotic tunes sea shanties

Answer rating: 100% (QA)

A Mutual Fund Return Return Alger Capital Appreciation 235 0 Alger LargeCap Growth 228 5 Alger MidCa... View the full answer