Question

In: Math

You probably regard your university education as an investment. You spend your valuable time, effort, and...

You probably regard your university education as an investment. You spend your valuable time, effort, and tuition fees and in return you obtain a degree. The provincial and federal governements also regard their funding of universities to be an investment. But is the investment equally effective in producing graduates across all provinces? The data bellow indicates the number of graduates at the bachelors, masters and doctorate levels and funding from four sources: Investment of university endowment funds, provincial funding, federal funding, tuition fees. Can we estimate the number of graduates from the level of these sources of funding? Does population size impact the equation? What other factors could influence results?

		Population size	Bachelors	Masters	Doctorate	Investment Income	Federal	Provincial	Tuition
1	Alberta	4,067,176	15720	3297	579	126680000	311184000	2110750000	798612000
2	British Columbia	4,631,000	16980	4488	393	136505000	352119000	2052199000	1021043000
3	Manitoba	1,282,000	5835	708	96	23152000	82805000	496334000	190402000
4	New Brunswick	753,915	4344	504	45	24377000	54219000	200677000	132086000
5	Newfoundland and Labrador	528,449	2760	531	51	3757000	61676000	292731000	72502000
6	Nova Scotia	942,927	7959	1716	111	32551000	98062000	359035000	318869000
7	Ontario	13,600,000	84714	13095	2049	438746000	1132905000	5010652000	3334466000
8	Prince Edward Island	146,284	660	48	9	2134000	17553000	63118000	35506000
9	Quebec	8,215,000	33438	9972	1428	136634000	745905000	4307043000	700697000
10	Saskatchewan	1,130,000	2979	435	63	45108000	108851000	589425000	176926000

Expert Solution

The regression equation is defined as,

Where Y = Total graduates, X1 = Population size, X2 = Investment Income, X3 = Federal funding, X4 = Provincial funding, X5 = Tution fees

Under the Homoskedasticity assumption, the expected value of error term will be zero

Now, the regression analysis is done in excel by following steps

Step 1: Write the data values in excel. Where, the total gradualte is the sum of bachelors, masters and doctorate. The screenshot is shown below,

Step 2: DATA > Data Analysis > Regression > OK. The screenshot is shown below,

Step 3: Select Input Y Range: 'Total graduate' column, Input X Range: all the other columns then OK. The screenshot is shown below,

The result is obtained. The screenshot is shown below,

The regression equation is,

From the regression output summary, we can see that only the variable Provincial funding is significant at 10% significant level. All the other variables are not significant.

Explanatory variable	Coefficient	P-value		Significance level
Population size	0.00264127	0.68226144	>	0.1	Not significant
Investment Income	-5.416E-05	0.61981904	>	0.1	Not significant
Federal	0.00010337	0.06297012	<	0.1	Not significant
Provincial	-1.218E-05	0.1123386	>	0.1	Significant
Tuition	9.6499E-06	0.51307473	>	0.1	Not significant

Hence we can say that population doesnot impact the equation (insignificant variable in equation). Only the the variable Provincial funding impact the equation (statistically significant variable in equation)

milcah answered 1 year ago

Think about the money you spend every day. You probably spend the most money at or...

Think about the money you spend every day. You probably spend the most money at or near the beginning of each month. However, after all the bills are paid, you have what are often referred to as discretionary funds. That’s money you can spend any way you wish. Please tell us on what types of things you spend that extra-or discretionary-money? How will learning the Quicken software help you determine whether you have discretionary funds, and if so, how much...

How much time and effort should we spend on a feasibility study – what is it...

How much time and effort should we spend on a feasibility study – what is it dependant on?

in the Spring you plant your crops and you invest all your time and effort in...

in the Spring you plant your crops and you invest all your time and effort in the crops until harvest in the late Fall. The profit you derive from selling your crops is how you live until the next harvest. If you plant all corn in your fields and so does everyone else, when harvest comes the market is flooded with corn and has nothing else to sell to customers, so the price of corn drops like a rock and...

Every month you spend $1500 on education and the rest of your income is used for...

Every month you spend $1500 on education and the rest of your income is used for the consumption of other goods. On the unforeseen circumstance of COVID-19, the government ensures no change in your income through a cash transfer to your nominated bank account. At the same time, the university provides you a $1000 voucher to use for your education expense only. If your preference pattern satisfies all textbook assumptions, in a diagram, show the effect of the voucher on...

Every month you spend $1, 500 on education and the rest of your income is used...

Every month you spend $1, 500 on education and the rest of your income is used for the consumption of other goods. On the unforeseen circumstance of COVID-19, the government ensures no change in your income through a cash transfer to your nominated bank account. At the same time, the university provides you a $1000 voucher to use for your education expense only. If your preference pattern satisfies all textbook assumptions, in a diagram, show the effect of the voucher...

A large Midwestern university is interested in estimating the mean time that students spend at the...

A large Midwestern university is interested in estimating the mean time that students spend at the student recreation center per week. A previous study indicated that the standard deviation in time is about 25 minutes per week. If the officials wish to estimate the mean time within ± 4 minutes with a 90 percent confidence, what should the sample size be? 106 Can't be determined without the sample mean. 105 105.685

During your lunchtime, which you usually spend at the university canteen in the presence of other...

During your lunchtime, which you usually spend at the university canteen in the presence of other students, one particular accounting student who was having difficulty with the textbook complained that he did not understand which costs were to be regarded as part of the acquisition cost of land, which costs were to be attributed to buildings under construction, and which were to be treated as an expense. Explain the basic principles to be followed. Are there any difficulties in applying...

Write an essay about the online education at your university ?

After all the time, effort and care you put into your work search, it can be...

After all the time, effort and care you put into your work search, it can be tempting to leap at the first job you’re offered without negotiating salary, benefits and other terms of employment. With the exception of some entry-level positions and jobs where you’re automatically placed on a grid determined by education and experience, many employers expect you to make a counter- offer and negotiate terms. To effectively negotiate a job offer, you need to understand and evaluate the...

1.) The time college students spend on the internet follows a Normal distribution. At Johnson University,...

1.) The time college students spend on the internet follows a Normal distribution. At Johnson University, the mean time is 5.5 hours per day with a standard deviation of 1.1 hours per day. If 100 Johnson University students are randomly selected, what is the probability that the average time spent on the internet will be more than 5.8 hours per day? Round to 4 places. If 100 Johnson University students are randomly selected, what is the probability that the average...