PLEASE HELP ME!!!

Bock Investment Services

Lisa Rae Bock started Bock Investment Services (BIS) in 2014 with the goal of making BIS the leading money market advisory service in South Carolina. To provide a better service for her present clients and to attract new clients, she has developed a weekly newsletter. Lisa has been considering adding a new feature to the newsletter that will report the results of a weekly survey of fund managers. To investigate the feasibility of offering this service, and to determine what type of information to include in the newsletter, Lisa selected a random sample of 45 money market funds. The data represents fund assets and yields for the past seven and 30 days. Before calling the money market fund managers to obtain additional data, Lisa decided to do some preliminary analysis of the data already collected.

Report:

1. Use appropriate descriptive statistics to summarize the data on assets and yields for the money market funds. Display in a formatted table and discuss/interpret at least 3 statistics that are of interest to the study or may affect the study in a positive or negative way.

2. The average Assets for all money market funds is $3000. Using a .05 level of significance to determine if Lisas sample is an accurate reflection of the money market fund population. Interpret and discuss your findings.

3. Develop a 95% and a 99% confidence interval of the mean Assets, 7-day and 30- day yields for the population of money market funds. Provide a managerial interpretation of each interval estimate.

4. Discuss the implication of your findings in terms of how Lisa could use this type of information in preparing her weekly newsletter.

5. Give your recommendations/conclusions of your finding and discuss what other information you would recommend that Lisa gather to provide the most useful information to her clients? Justify your recommendations.

The data for the report:

Assets ($millions)	7-Day Yield (%)	30-Day Yield (%)
103.9	4.1	4.08
156.7	4.79	4.73
496.5	4.17	4.13
197.8	4.37	4.32
2755.4	4.54	4.47
707.6	3.88	3.83
1.7	4.29	4.22
2707.8	4.14	4.04
122.8	4.03	3.91
694.7	4.25	4.19
217.3	3.57	3.51
38.4	2.67	2.61
4832.8	4.01	3.89
81.7	4.51	4.41
506.2	4.17	4.11
738.7	4.41	4.34
13272.8	4.51	4.42
172.8	4.6	4.48
105.6	3.87	3.85
996.8	3.97	3.92
1079	4.07	4.01
801.4	4.11	3.96
409.4	3.83	3.82
794.3	4.32	4.23
1008.3	4.08	4
53.6	3.99	3.91
226.4	3.93	3.87
481.3	4.28	4.26
388.9	4.61	4.64
10.6	4.13	4.05
27005.6	4.24	4.18
113.4	4.22	4.2
517.3	4.22	4.14
291.5	4.26	4.17
1991.7	4.5	4.4
161.6	4.28	4.2
6835.1	4.2	4.16
1408.8	3.91	3.86
10531	4.16	4.07
2947.6	4.16	4.12
1502.2	4.18	4.13
470.2	4.37	4.29
175.5	4.2	4.19
323.7	3.96	3.89
1330	4.24	4.21