Question: I want to understand how to create a formula based on the following hypothetical case.
Let's assume have 57,000 in scholarship funds to be given to students who apply for scholarships.
Let's say I have 359 total students enrolled in 13 classes.
I want to determine what portion (percentage) of the scholarship funds should be fairly applied to each class based on enrollment. I was thinking that a formula can be created so each year, depending on funds received for scholarships, could be fairly given toto those students who request funding, but fairly distributed among the various classes.
The first class has 29 students which I calculate as 8% of the total enrollment.
Let's say those students pay 7,860 in tuition per year which is about 25% of the total tuition paid over all classes (906,987).
Tuition varies for each class as would enrollment.
Is there a way to create a formula that I could change depending on enrollment and depending on amount of scholarship funds?
TutorTeddy.com & Boston Predictive Analytics
[ Email your Statistics or Math problems to email@example.com (camera phone photos are OK) ]
Boston Office (Near MIT/Kendall 'T'):
Cambridge Innovation Center,
One Broadway, 14th Floor,
Cambridge, MA 02142,
Dallas Office (Near Galleria):
15950 Dallas Parkway,
Dallas, TX 75248,