computer assignment about (Hi Lo method, Scatter graph, least squares regression)

Anonymous
timer Asked: Oct 16th, 2018
account_balance_wallet $9.99

Question Description

1. select the Hi lo method tab and perform the required

2. select the SCATTERGRAP tab

you will see that the scatter graph has been prepared for you, draw a line(using the inset shape function) such that approximately equal numbers of points fall above and below the line, choose 2 points on or very near to the line and use the Hi Lo method answer the required

3. Select the REGRESSION tab

the report from the regression analysis is there, interpret the report to answer the questions.

Unformatted Attachment Preview

BUSI 3320 Computer Assignment #2 The following cost and activity data is available for KEEKOO Inc. for 2017 M Hours January February March April May June July August September October November December Independent variable 2500 2900 1900 3100 3800 3300 4100 3500 2000 3700 4700 4200 39700 Cost Dependent variable $ 18,400 $ 21,000 $ 11,200 $ 20,100 $ 29,250 $ 24,000 $ 24,750 $ 22,750 $ 19,700 $ 26,000 $ 26,400 $ 27,750 $ 271,300 y= electricity cost $35,000 $30,000 $25,000 $20,000 $15,000 $10,000 $5,000 $- Required # 2 A scattergraph is provided for you. Using the insert shape function draw a line that passes through most of the data points Choose 2 data points on or very close to the line and use the Hi Lo method to determine: ( not all answers will be the same!) 1) The estimated variable cost: 2) The estimated fixed cost: 3) The equation to predict electricity costs: 0 500 1000 1500 Scatter graph 1500 2000 2500 3000 3500 4000 4500 5000 X = machine hours BUSI 3320 Computer Assignment #2 The following cost and activity data is available for KEEKOO Inc. for 2017 M Hours January February March April May June July August September October November December Cost Independent variable 2500 2900 1900 3100 3800 3300 4100 3500 2000 3700 4700 4200 39700 Dependent variable $ 18,400 $ 21,000 $ 11,200 $ 20,100 $ 29,250 $ 24,000 $ 24,750 $ 22,750 $ 19,700 $ 26,000 $ 26,400 $ 27,750 $ 271,300 1) The estimated variable cost is: 2) The estimated fixed cost is: 3) The equation to predict electricity costs is: BUSI 3320 Computer Assignment #2 The following cost and activity data is available for KEEKOO Inc. for 2017 January February March April May June July August September October November December M Hours Independent variable 2500 2900 1900 3100 3800 3300 4100 3500 2000 3700 4700 4200 39700 Cost Dependent variable $ 18,400 $ 21,000 $ 11,200 $ 20,100 $ 29,250 $ 24,000 $ 24,750 $ 22,750 $ 19,700 $ 26,000 $ 26,400 $ 27,750 $ 271,300 A summary report is provided ( right of the data, highlighted in yellow) What is the cost equation to predict electricty costs? What is the estimate of the fixed costs? What is the estimtae of the variable costs? How much of the variation in electricity costs is explained by machine hours? Regre SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.858430269 0.736902527 0.710592779 2656.212156 12 ANOVA df Regression Residual Total Intercept X Variable 1 1 10 11 SS MS F Significance F 197614536.5 1.98E+08 28.00873 0.000351382 70554630.2 7055463 268169166.7 Coefficients Standard Error t Stat P-value 6513.1051 3136.412892 2.07661 0.064564 4.865056393 0.919265994 5.292327 0.000351 Lower 95% Upper 95% -475.2583205 13501.46852 2.816804117 6.913308669 Lower 95.0% Upper 95.0% -475.2583205 13501.46852 2.816804117 6.913308669 1 2 3 COMPUTER ASSIGNMENT #2 - 3.5 marks DUE October 18, 2018 at 11:45 pm ( to be submitted via drop box on moodle) INSTRUCTIONS This assignment requires that you work with a set of data and use the three estimation methods learned in class ( Hi Lo method; Scatter graph; Least squares Regression) Select the HI LO METHOD tab and perform the required Select the SCATTERGRAP tab You will see that the scatter graph has been prepared for you Draw a line ( using the insert shape function) such that approximately equal numbers of points fall above and below the line Choose 2 points on or very near to the line and use the Hi Lo method answer the required Select the REGRESSION tab The report from the regression analysis is there Interpret the report to answer the questions bove and below the line ...
Purchase answer to see full attachment

Tutor Answer

Professor_Aldin
School: UT Austin

Hi, your assignment is done :). I am very happy to help your assignments and I am hoping to work with you again..here is the assignment the calculations in excel contains formula where you can learn about :). I indicated all answers.

BUSI 3320
Computer Assignment #2
The following cost and activity data is available for KEEKOO Inc. for 2017
M Hours

January
February
March
April
May
June
July
August
September
October
November
December

Cost

Dependent
Independent variable
variable
2500
$ 18,400
2900
$ 21,000
1900
$ 11,200
3100
$ 20,100
3800
$ 29,250
3300
$ 24,000
4100
$ 24,750
3500
$ 22,750
2000
$ 19,700
3700
$ 26,000
4700
$ 26,400
4200
$ 27,750
39700
$ 271,300

y=
ele
ctr
icit
y
co
st

$35,000

$30,000

$25,000

$20,000

$15,000

$10,000

$5,000

$0

Required # 2 A scattergraph is provided for you.
Using the insert shape function draw a line that passes through most of the data points
Choose 2 data points on or very close to the line and use the Hi Lo method to determine:
( not all answers will be the same!)

1) The estimated variable cost:
Formula for Hi Lo method:
Calculation:
2) The estimated fixed cost:

(cost at high point) - (cost at low point)
(vol. at high point) - (vol. at low point)
$
21,000 $ 18,400
$
=
$
2,900 1900
$
HIGH POINT Calculation
Total cost at the high point:
Variable at the high point:
Volume at the high point
2,900
Variable cost per hours $
2.60
Total variable costs at the...

flag Report DMCA
Review

Anonymous
Tutor went the extra mile to help me with this essay. Citations were a bit shaky but I appreciated how well he handled APA styles and how ok he was to change them even though I didnt specify. Got a B+ which is believable and acceptable.

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors