# Project #19533 - Statistics Excel

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
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews