Business statisticser.

Business statisticser Project description the work should be done in microsoft excel. Also, i will atach a document relating to questions. 2. The file Mutual Funds includes asset value, return, expense ratio and other information about 868 mutual funds. a. Construct a percentage summary table for number of different types of mutual funds by category and objective (i.e. œlarge-cap growth, œlarge-cap value, œmid-cap growth, œmid-cap value, œsmall-cap growth, œsmall-cap value) b. Construct a bar chart, a pie chart, and a Pareto chart for the types of mutual funds. c. Do you prefer using a Pareto chart or a pie chart for these data? Why? d. Create contingency tables (i) based on category and objective of funds and (ii) based on category and risk level of mutual funds using both number of funds and average asset values. e. What conclusions can you reach based on tables created in part d). 3. The file Mutual Funds includes asset value, return, expense ratio and other information about 868 mutual funds. a. Construct a frequency distribution and a percentage distribution of mutual fund returns in 2006. b. Construct a histogram and a percentage polygon of mutual fund returns in 2006. c. Construct a cumulative percentage distribution and plot a cumulative percentage polygon (ogive) of mutual fund returns in 2006. d. Based on (a) through (c), what conclusions can you reach mutual fund returns in 2006? e. Construct a scatter plot of mutual fund returns and asset values in 2006. f. What is the relationship between the mutual fund returns and asset values in 2006? Complete the following for the mutual fund assets in 2006 (in $millions). g. Compute the mean, median, first quartile, and third quartile. h. Compute the range, interquartile range, variance, standard deviation, and coefficient of variation. i. Construct a boxplot. Are the data skewed? If so, how? j. Based on the results of (a) through (c), what conclusions can you reach concerning the the mutual fund assets in 2006 (in $millions)? k. Compute the correlation coefficient between the mutual fund returns and asset values in 2006. l. What conclusions can you reach from the results of (k)? 4. The owner of a restaurant serving Continental-style entrÃ©es was interested in studying ordering patterns of patrons for the Friday-to-Sunday weekend time period. Records were maintained that indicated the demand for dessert during the same time period. The owner decided to study two other variables, along with whether a dessert was ordered: the gender of the individual and whether a beef entrÃ©e was ordered. The results are as follows: A waiter approaches a table to take an order for dessert. What is the probability that the first customer to order at the table (show your calculation) a. orders a dessert? b. orders a dessert or has ordered a beef entrÃ©e? c. is a female and does not order a dessert? d. is a female or does not order a dessert? e. Suppose the first person from whom the waiter takes the dessert order is a female. What is the probability that she does not order dessert? f. Are gender and ordering dessert independent? g. Is ordering a beef entrÃ©e independent of whether the person orders dessert? we do not need referencing. you should stick to all the rules mentioned above. also, i need all the calculations. all the answers should be open. Please, use Excel to prepare, graphs, charts and tables, and for calculations. it’s not an essay, it is statistics, more about calculations. first and second questions related to the file that i’ll send later. the work is not based on word count, it’s more about equations. so, we do not need many words to explain open questions. just right answers.