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

*label*Business Finance

*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

Purchase answer to see full attachment

## Tutor Answer

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

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