Using excel file xr15012 complete the following:

1. Please do a scatter plot between partners and gross revenue by using partners as your independent and gross revenue as your dependent variable, Include a linear trendline and show the corresponding equation on the graph (5 pts)

2. Find out the predicted gross revenue if a firm has 15 partners by using the equation you found to part a. (5 pts)

Using excel file xr02051 answeer the following:

3. Construct a cross tabulation table that shows the average tutiton values for the schools using the campus setting and the public/private nature of the school. Please put the public/private in the rows and the campus setting field in the columns.

The codes refer to the following: for setting 1=urban, 2=suburban, 3=rural for campus setting values, and for private/public the codes are 1=public, 2=private (5 pts)

4. Please comment on which type of schools are the cheapest vs the most expensive based on your cross tabulation. (ex: private schools in urban settings are the most expensive in terms of tutiton while public schools in rural settings are the cheapest) (5 pts)

5. If there are 10 students in a class that are from CT and the class size is 25, what is the probability that 3 of the randomly selected 5 students from this class will not be from CT? Use excel to find the answer and only provide the answer (as a percentage) and the excel formula used. (5 pts)

Subject | Mathematics |

Due By (Pacific Time) | 12/11/2013 12:00 am |

Tutor | Rating |
---|---|

pallavi Chat Now! |
out of 1971 reviews More.. |

amosmm Chat Now! |
out of 766 reviews More.. |

PhyzKyd Chat Now! |
out of 1164 reviews More.. |

rajdeep77 Chat Now! |
out of 721 reviews More.. |

sctys Chat Now! |
out of 1600 reviews More.. |

sharadgreen Chat Now! |
out of 770 reviews More.. |

topnotcher Chat Now! |
out of 766 reviews More.. |

XXXIAO Chat Now! |
out of 680 reviews More.. |