an excel assignment, all the requirement listed in document

profilejkfhkewqdwq
lastname_firstname_sectionxxxxx-acc-excelexercise1_1.xlsx
Home>Business & Finance homework help>Accounting homework help>an excel assignment, all the requirement listed in document

Data

YY-MM Year Month Inspection Cost Inspection Hrs # of Batches Cost @ Min Hrs Cost @ Max Hrs
2014-01 Calc Year Calc Month $17,689.00 100 10 Blank if <> Min hrs, $$$ otherwise Blank if <> Maxx hrs, $$$ otherwise
2014-02 Calc Year Calc Month $18,350.00 120 20 Blank if <> Min hrs, $$$ otherwise Blank if <> Maxx hrs, $$$ otherwise
2014-03 Calc Year Calc Month $13,125.00 60 15 Blank if <> Min hrs, $$$ otherwise Blank if <> Maxx hrs, $$$ otherwise
2014-04 Calc Year Calc Month $28,000.00 320 30 Blank if <> Min hrs, $$$ otherwise Blank if <> Maxx hrs, $$$ otherwise
2014-05 Calc Year Calc Month $30,560.00 240 25 Blank if <> Min hrs, $$$ otherwise Blank if <> Maxx hrs, $$$ otherwise
2014-06 Calc Year Calc Month $31,755.00 200 40 Blank if <> Min hrs, $$$ otherwise Blank if <> Maxx hrs, $$$ otherwise
2014-07 Calc Year Calc Month $40,750.00 280 35 Blank if <> Min hrs, $$$ otherwise Blank if <> Maxx hrs, $$$ otherwise
2014-08 Calc Year Calc Month $29,500.00 230 22 Blank if <> Min hrs, $$$ otherwise Blank if <> Maxx hrs, $$$ otherwise
2014-09 Calc Year Calc Month $47,570.00 350 50 Blank if <> Min hrs, $$$ otherwise Blank if <> Maxx hrs, $$$ otherwise
2014-10 Calc Year Calc Month $36,740.00 270 45 Blank if <> Min hrs, $$$ otherwise Blank if <> Maxx hrs, $$$ otherwise
2014-11 Calc Year Calc Month $43,500.00 350 38 Blank if <> Min hrs, $$$ otherwise Blank if <> Maxx hrs, $$$ otherwise
2014-12 Calc Year Calc Month $26,780.00 200 18 Blank if <> Min hrs, $$$ otherwise Blank if <> Maxx hrs, $$$ otherwise
2015-01 Calc Year Calc Month $28,500.00 140 28 Blank if <> Min hrs, $$$ otherwise Blank if <> Maxx hrs, $$$ otherwise
2015-02 Calc Year Calc Month $17,000.00 160 14 Blank if <> Min hrs, $$$ otherwise Blank if <> Maxx hrs, $$$ otherwise
- - - - - - - -
TOTALS COUNT N/A TOTAL TOTAL TOTAL
Average (Fn) Avg (fn) Avg (fn) Avg (fn)
Average (Calc) Avg (calc) Avg (copycalc) Avg (copycalc)
Minimum Min Min Min Avg (fn)
Maximum Max Max Max Avg (fn)
HIGH LOW (Insp Hrs)
Total Cost = FC + VC/Insp Hr x # of Inspect Hrs
Calc Calc Calc INPUT HRS HERE
Regr #1: Cost Function for InspHrs
Total Cost = FC + VC/Insp Hr x # of Inspect Hrs
Calc Reference Reference INPUT HRS HERE
Regr #2: Cost Function for NumBatches
Total Cost = FC + VC/Batch x # of Batches
Calc Reference Reference INPUT HRS HERE
Regr #3: Cost Function for Mult Regr
Total Cost = FC + VC/Insp Hr x # of Inspect Hrs + VC/Batch x # of Batches
Calc Reference Reference INPUT HRS HERE Reference INPUT HRS HERE
Confidence Interval for Mult Regr .90, .95 or .99
Yf + tp x Se
Reference + Calc Reference
Calc < Yf < Calc

Scatterplot

Output

Regr-InspHrs

Output

Regr-NumBatches

Output

Regr-Mult

Output

TDist

DF 90% 95% 99%
1 6.314 12.708 63.657
2 2.920 4.303 9.925
3 2.353 3.182 5.841
4 2.132 2.776 4.604
5 2.015 2.571 4.032
6 1.943 2.447 3.707
7 1.895 2.365 3.499
8 1.860 2.306 3.355
9 1.833 2.262 3.250
10 1.812 2.228 3.169
11 1.796 2.201 3.106
12 1.782 2.179 3.055
13 1.771 2.160 3.055
14 1.761 2.145 3.012
15 1.753 2.131 2.947
16 1.746 2.120 2.921
17 1.740 2.110 2.898
18 1.734 2.101 2.878
19 1.729 2.093 2.861
20 1.725 2.086 2.845
30 1.697 2.042 2.750
31 1.645 1.960 2.576