Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

help me pls Activity: The below table contains the number of undergraduates, postgraduates and total expenses for a university in the last 13 years. Use

help me pls

image text in transcribed
Activity: The below table contains the number of undergraduates, postgraduates and total expenses for a university in the last 13 years. Use the regression analysis tool in MS Excel to estimate a, b1 and b2. Total expenses=a+b1*undergrauates+b2*postgraduates Year Postgraduates Undergraduates Expenses Sm 2001 4580 9395 153.402325 2002 4280 9595 125.209399 2003 5 153 9594 124.208021 2004 5204 9840 202.551212 2005 5039 10532 211.952150 2005 5425 115 15 222. 155885 2002 5125 12280 33051234 2008 5259 13189 235.442301 2009 2132 14523 251.400814 2010 5924 15884 220.545422 2011 5224 12052 292.089822 2012 5032 20853 342.053589 2013 5305 24945 393982000 1. Predict the total expenses based on 5,954 postgraduates and 22,123 undergraduates. 2. If the total expense is budgeted for $500m and undergraduates for 32,000, how many postgraduates do you expect from the regression model

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

Students also viewed these Accounting questions