Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 11, 2024

Complete the following Activities/questions in the spreadsheet: Chapter 14 Data Analytics 1. Conduct Multiple Regression Analysis using the Data Analysis Toolpak a. Dependent Variable(Y): Maintenance

Complete the following Activities/questions in the spreadsheet: Chapter 14 Data Analytics 1.

Conduct Multiple Regression Analysis using the Data Analysis Toolpak a. Dependent Variable(Y): Maintenance Cost b. Independent Variables(X): i. EngineType(0=diesel) - x1 ii. Age - x2 iii. Odometer Miles - x3 iv. Miles - x4 2.

Type out the complete Regression equation using the calculated coefficients in the format as described in the text a. = a + b1x1 + b2x2 + b3x3 + b4x4 3.

Predict the maintenance cost of a bus with the following characteristics:

a. Gasoline engine

b. 8 years old

c. Odometer = 85,000 miles

d. Miles since last maintenance = 12,000

ID Manufacturer Engine Type Capacity Maintenance cost Engine Type (0=diesel) Age Odometer Miles Miles

10 Keiser Gasoline 14 4646 1 5 54375 11973

396 Thompson Diesel 14 1072 0 2 21858 11969

122 Bluebird Gasoline 55 9394 1 10 116580 11967

751 Keiser Diesel 14 1078 0 2 22444 11948

279 Bluebird Diesel 55 1008 0 2 22672 11925

500 Bluebird Gasoline 55 5329 1 5 50765 11922

520 Bluebird Diesel 55 4794 0 10 119130 11896

759 Keiser Diesel 55 3952 0 8 87872 11883

714 Bluebird Diesel 42 3742 0 7 73703 11837

875 Bluebird Diesel 55 4376 0 9 97947 11814

600 Bluebird Diesel 55 4832 0 10 119860 11800

953 Bluebird Diesel 55 5160 0 10 117700 11798

101 Bluebird Diesel 55 1955 0 4 41096 11789

358 Bluebird Diesel 55 2775 0 6 70086 11782

29 Bluebird Gasoline 55 5352 1 6 69438 11781

365 Keiser Diesel 55 3065 0 6 63384 11778

162 Keiser Gasoline 55 3143 1 3 31266 11758

686 Bluebird Diesel 55 1569 0 3 34674 11757

370 Keiser Gasoline 55 7766 1 8 86528 11707

887 Bluebird Diesel 55 3743 0 8 93672 11704

464 Bluebird Gasoline 55 2540 1 3 34530 11698

948 Keiser Diesel 42 4342 0 9 97956 11691

678 Keiser Diesel 55 3361 0 7 75229 11668

481 Keiser Gasoline 6 3097 1 3 34362 11662

43 Bluebird Gasoline 55 8263 1 9 102969 11615

704 Bluebird Diesel 55 4218 0 8 83424 11610

814 Bluebird Diesel 55 2028 0 4 40824 11576

39 Bluebird Gasoline 55 5821 1 6 69444 11533

699 Bluebird Gasoline 55 9069 1 9 98307 11518

75 Bluebird Diesel 55 3011 0 6 71970 11462

693 Keiser Gasoline 55 9193 1 9 101889 11461

989 Keiser Diesel 55 4795 0 9 106605 11418

982 Bluebird Diesel 55 505 0 1 10276 11359

321 Bluebird Diesel 42 2732 0 6 70122 11358

724 Keiser Diesel 42 3754 0 8 91968 11344

732 Keiser Diesel 42 4640 0 9 101196 11342

880 Keiser Gasoline 55 8410 1 9 97065 11336

193 Thompson Diesel 14 5922 0 11 128711 11248

884 Bluebird Diesel 55 4364 0 9 92457 11231

57 Bluebird Diesel 55 3190 0 7 79240 11222

731 Bluebird Diesel 42 3213 0 6 68526 11168

61 Keiser Diesel 55 4139 0 9 103536 11148

135 Bluebird Diesel 55 3560 0 7 76426 11127

833 Thompson Diesel 14 3920 0 8 90968 11112

671 Thompson Gasoline 14 6733 1 8 89792 11100

692 Bluebird Diesel 55 3770 0 8 93248 11048

200 Bluebird Diesel 55 5168 0 10 103700 11018

754 Keiser Diesel 14 7380 0 14 146860 11003

540 Bluebird Gasoline 55 3656 1 4 45284 10945

660 Bluebird Gasoline 55 6213 1 6 64434 10911

353 Keiser Gasoline 55 4279 1 4 45744 10902

482 Bluebird Gasoline 55 10575 1 10 116534 10802

398 Thompson Diesel 6 4752 0 9 95922 10802

984 Bluebird Diesel 55 3809 0 8 87664 10760

977 Bluebird Diesel 55 3769 0 7 79422 10759

705 Keiser Diesel 42 2152 0 4 47596 10755

767 Keiser Diesel 55 2985 0 6 71538 10726

326 Bluebird Diesel 55 4563 0 9 107343 10724

120 Keiser Diesel 42 4723 0 10 110320 10674

554 Bluebird Diesel 42 1826 0 4 44604 10662

695 Bluebird Diesel 55 1061 0 2 23152 10633

9 Keiser Gasoline 55 3527 1 4 46848 10591

861 Bluebird Gasoline 55 9669 1 10 106040 10551

603 Keiser Diesel 14 2116 0 4 44384 10518

156 Thompson Diesel 14 6212 0 12 140460 10473

427 Keiser Gasoline 55 6927 1 7 73423 10355

883 Bluebird Gasoline 55 1881 1 2 20742 10344

168 Thompson Gasoline 14 7004 1 7 83006 10315

954 Bluebird Diesel 42 5284 0 10 101000 10235

768 Bluebird Diesel 42 3173 0 7 71778 10227

490 Bluebird Gasoline 55 10133 1 10 106240 10210

725 Bluebird Diesel 55 2356 0 5 57065 10209

45 Keiser Diesel 55 3124 0 6 60102 10167

38 Keiser Gasoline 14 5976 1 6 61662 10140

314 Thompson Diesel 6 5408 0 11 128117 10128

507 Bluebird Diesel 55 3690 0 7 72849 10095

40 Bluebird Gasoline 55 9573 1 10 118470 10081

918 Bluebird Diesel 55 2470 0 5 53620 10075

387 Bluebird Gasoline 55 6863 1 8 89960 10055

418 Bluebird Diesel 55 4513 0 9 104715 10000

Type out the complete Regression equation using the calculated coefficients in the format as described in the text.

Round coefficients to 2 decimal places.

= a + b₁x₁ + b₂x₂ + b₃x₃ + b₄x₄

=

Using the coefficents from the regression output, predict the following using the values from the instructions

Component Coefficient(a/b) Prediction Value(x) Cacluation

Intercept

Engine Type (0 = diesel)

Age

Odometer Miles

Miles since last maintenance

Predicted annual maintenance cost

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access with AI-Powered Solutions

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

Step: 2

Step: 3

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

Microeconomics An Intuitive Approach with Calculus

Authors: Thomas Nechyba

1st edition

538453257, 978-0538453257

Students also viewed these Mathematics questions

Question

★★★★★

Match (by letter) the following terms with their definitions. Each letter is used only once. Terms ______ 1. Publicly held corporation. ______ 2. Organization chart. ______ 3. Articles of...

Answered: 1 week ago

Question

★★★★★

11. accounting LLA Repeat the LLA construction in problem 10 above, but with the "anchoring point" at q = 12. (So you want the LLA to agree with CSR(12; P) and its slope to equal marginal cost at q =...

Answered: 1 week ago

Question

★★★★★

Determine the overall sample size required so that a 99% confidence interval for the difference of two proportions will have a margin of error of ???????? = 0.04 when (a) ???? ???? = 0.25 and ????...

Answered: 1 week ago

Question

★★★★★

The 2017 comparative income statement and balance sheet of Flowell Design Ltd. follow: Flowell Design Ltd. had no non-cash financing and investing transactions during 2017. During the year, there...

Answered: 1 week ago

Question

★★★★★

Explain why and describe how Coca-Cola company would adopt job order costing system and state one advantage and one disadvatage the Coca Cola would face using the job order costing system.

Answered: 1 week ago

Question

★★★★★

Please provide an answer and explain why Which of the following concerning operating taxes are true? i. With full information, operating taxes can be computed without error. ii. The effects of...

Answered: 1 week ago

Question

★★★★★

A gift shop sells 400 boxes of scented candles a year. The ordering cost is $$60$ for scented candles, and holding cost is $$24$ per box per year. What is the minimum annual amount of these...

Answered: 1 week ago

Question

★★★★★

A car rental agency uses 96 boxes of staples a year. The boxes cost $$4$ each. It costs $$10$ to order staples, and it costs $$0.80$ to hold a box of staples in inventory for 1 year. How many...

Answered: 1 week ago

Question

★★★★★

How do you add two harmonic motions having different frequencies?

Answered: 1 week ago

Question

★★★★★

Pablo, Dirk and Franz run the only bar in town. Pablo wants to sell as many drinks as possible without losing money. Dirk wants the bar to bring in as much revenue as possible. Franz wants to make...

Answered: 1 week ago

Question

★★★★★

Continue with the gamma model of Exercise 5-2. (a) Show that \(\partial Q_{N}(\boldsymbol{\beta}) / \partial \boldsymbol{\beta}=\boldsymbol{N}^{-1} \sum_{i} 2\left[\left(y_{i}-\exp...

Answered: 1 week ago

Question

★★★★★

1) Answer the following questions based on the weekly market demand schedule for cups of coffee at the College Coffee Shop, as well as the demand schedules for three students: Lynn, Nancy, and Sid,...

Answered: 1 week ago

Question

★★★★★

Consider the following statement: Starting from scratch underplays the fact that significant redesign has to be planned and implemented in a real-life context that wont go away. Hospitals...

Answered: 1 week ago

Question

★★★★★

Assess the extent to which different types of organizational structure and form can cope with and adapt to a variety of change processes. LO4

Answered: 1 week ago

Question

★★★★★

Diagnose organizational culture as the first step in the process of culture change. LO4

Answered: 1 week ago

Previous Question Next Question

ID	Manufacturer	Engine Type	Capacity	Maintenance cost	Engine Type (0=diesel)	Age	Odometer Miles	Miles
10	Keiser	Gasoline	14	4646	1	5	54375	11973
396	Thompson	Diesel	14	1072	0	2	21858	11969
122	Bluebird	Gasoline	55	9394	1	10	116580	11967
751	Keiser	Diesel	14	1078	0	2	22444	11948
279	Bluebird	Diesel	55	1008	0	2	22672	11925
500	Bluebird	Gasoline	55	5329	1	5	50765	11922
520	Bluebird	Diesel	55	4794	0	10	119130	11896
759	Keiser	Diesel	55	3952	0	8	87872	11883
714	Bluebird	Diesel	42	3742	0	7	73703	11837
875	Bluebird	Diesel	55	4376	0	9	97947	11814
600	Bluebird	Diesel	55	4832	0	10	119860	11800
953	Bluebird	Diesel	55	5160	0	10	117700	11798
101	Bluebird	Diesel	55	1955	0	4	41096	11789
358	Bluebird	Diesel	55	2775	0	6	70086	11782
29	Bluebird	Gasoline	55	5352	1	6	69438	11781
365	Keiser	Diesel	55	3065	0	6	63384	11778
162	Keiser	Gasoline	55	3143	1	3	31266	11758
686	Bluebird	Diesel	55	1569	0	3	34674	11757
370	Keiser	Gasoline	55	7766	1	8	86528	11707
887	Bluebird	Diesel	55	3743	0	8	93672	11704
464	Bluebird	Gasoline	55	2540	1	3	34530	11698
948	Keiser	Diesel	42	4342	0	9	97956	11691
678	Keiser	Diesel	55	3361	0	7	75229	11668
481	Keiser	Gasoline	6	3097	1	3	34362	11662
43	Bluebird	Gasoline	55	8263	1	9	102969	11615
704	Bluebird	Diesel	55	4218	0	8	83424	11610
814	Bluebird	Diesel	55	2028	0	4	40824	11576
39	Bluebird	Gasoline	55	5821	1	6	69444	11533
699	Bluebird	Gasoline	55	9069	1	9	98307	11518
75	Bluebird	Diesel	55	3011	0	6	71970	11462
693	Keiser	Gasoline	55	9193	1	9	101889	11461
989	Keiser	Diesel	55	4795	0	9	106605	11418
982	Bluebird	Diesel	55	505	0	1	10276	11359
321	Bluebird	Diesel	42	2732	0	6	70122	11358
724	Keiser	Diesel	42	3754	0	8	91968	11344
732	Keiser	Diesel	42	4640	0	9	101196	11342
880	Keiser	Gasoline	55	8410	1	9	97065	11336
193	Thompson	Diesel	14	5922	0	11	128711	11248
884	Bluebird	Diesel	55	4364	0	9	92457	11231
57	Bluebird	Diesel	55	3190	0	7	79240	11222
731	Bluebird	Diesel	42	3213	0	6	68526	11168
61	Keiser	Diesel	55	4139	0	9	103536	11148
135	Bluebird	Diesel	55	3560	0	7	76426	11127
833	Thompson	Diesel	14	3920	0	8	90968	11112
671	Thompson	Gasoline	14	6733	1	8	89792	11100
692	Bluebird	Diesel	55	3770	0	8	93248	11048
200	Bluebird	Diesel	55	5168	0	10	103700	11018
754	Keiser	Diesel	14	7380	0	14	146860	11003
540	Bluebird	Gasoline	55	3656	1	4	45284	10945
660	Bluebird	Gasoline	55	6213	1	6	64434	10911
353	Keiser	Gasoline	55	4279	1	4	45744	10902
482	Bluebird	Gasoline	55	10575	1	10	116534	10802
398	Thompson	Diesel	6	4752	0	9	95922	10802
984	Bluebird	Diesel	55	3809	0	8	87664	10760
977	Bluebird	Diesel	55	3769	0	7	79422	10759
705	Keiser	Diesel	42	2152	0	4	47596	10755
767	Keiser	Diesel	55	2985	0	6	71538	10726
326	Bluebird	Diesel	55	4563	0	9	107343	10724
120	Keiser	Diesel	42	4723	0	10	110320	10674
554	Bluebird	Diesel	42	1826	0	4	44604	10662
695	Bluebird	Diesel	55	1061	0	2	23152	10633
9	Keiser	Gasoline	55	3527	1	4	46848	10591
861	Bluebird	Gasoline	55	9669	1	10	106040	10551
603	Keiser	Diesel	14	2116	0	4	44384	10518
156	Thompson	Diesel	14	6212	0	12	140460	10473
427	Keiser	Gasoline	55	6927	1	7	73423	10355
883	Bluebird	Gasoline	55	1881	1	2	20742	10344
168	Thompson	Gasoline	14	7004	1	7	83006	10315
954	Bluebird	Diesel	42	5284	0	10	101000	10235
768	Bluebird	Diesel	42	3173	0	7	71778	10227
490	Bluebird	Gasoline	55	10133	1	10	106240	10210
725	Bluebird	Diesel	55	2356	0	5	57065	10209
45	Keiser	Diesel	55	3124	0	6	60102	10167
38	Keiser	Gasoline	14	5976	1	6	61662	10140
314	Thompson	Diesel	6	5408	0	11	128117	10128
507	Bluebird	Diesel	55	3690	0	7	72849	10095
40	Bluebird	Gasoline	55	9573	1	10	118470	10081
918	Bluebird	Diesel	55	2470	0	5	53620	10075
387	Bluebird	Gasoline	55	6863	1	8	89960	10055
418	Bluebird	Diesel	55	4513	0	9	104715	10000

Type out the complete Regression equation using the calculated coefficients in the format as described in the text.
Round coefficients to 2 decimal places.

= a + b₁x₁ + b₂x₂ + b₃x₃ + b₄x₄

=



Using the coefficents from the regression output, predict the following using the values from the instructions

Component	Coefficient(a/b)	Prediction Value(x)	Cacluation
Intercept
Engine Type (0 = diesel)
Age
Odometer Miles
Miles since last maintenance
		Predicted annual maintenance cost