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
Report DMCA
TutorRating
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..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy