Provide a screen capture of your regression output

Assignment Help Management Theories

Reference no: EM133233409

Question: Regression analysis

Use the data in the Excel file "Regression example" and run a multiple regression analysis in Excel to predict the cost of producing 1300 A, 900 B, and 900 C in period 20.

In your Word Doc, provide a screen capture of your Regression output from Excel and your answer in a sentence in proper English.

Month	Cost ($)	Product A	Product B	Product C	What would be the cost of producing 1300 A, 900 B, and 900 C in period 20?
1	44439	515	541	928
2	43936	929	692	711
3	44464	800	710	824
4	41533	979	675	758
5	46343	1165	1147	635
6	44922	651	939	901
7	43203	847	755	580
8	43000	942	908	589
9	40967	630	738	682
10	48582	113	1175	1050
11	45003	1086	1075	984
12	44303	843	640	828
13	42070	500	752	708
14	44353	813	989	804
15	45968	1190	823	904
16	47781	1200	1108	1120
17	43202	731	590	1065
18	44074	1089	607	1132
19	44610	786	513	839
20	?

House	House size	Location	Garden size	Price
1	1000	center	0	569
2	2300	center	0.5	682
3	1500	center	1.9	575
4	2100	center	1	546
5	2050	center	0.6	567
6	3900	suburb	1.1	485
7	3100	suburb	2	460
8	3600	suburb	1.6	486
9	2900	suburb	2.5	404
10	2000	suburb	2.6	427
11	3500	suburb	1.3	487
12	2800	suburb	2	456
13	13500	suburb	8	657

Reference no: EM133233409

Questions Cloud

Create a timeline that captures the variety of change : Create a timeline that captures the variety of change initiatives you have personally led, been a part of, or consulted on for others

How the company should utilize social media applications : how the company should utilize social media applications to improve upon one or multiple weaknesses identified within the SWOT analysis and explain why

Provide strategic issues and opportunities for the company : Provide strategic issues and opportunities for the company name Sembcorp Industries. And from each strategic issue or opportunity please recommend strategies

Evaluation of impact of purchasing on business operations : Conduct an analysis of the fundamental concepts of purchasing management in the above-mentioned organization.

Provide a screen capture of your regression output : Provide a screen capture of your Regression output from Excel and your answer in a sentence in proper English.

Which error position was error if found, then how to correct : which error position was error if found, then how to correct (explain one method of how to correct that error on Receiver site as you are an error correction

What are the portion sizes for the different courses : Depending on the course in which the cheese is served, the portion sizes and the number of portions will change. What are the portion sizes for the different

Explain the importance of researching the culture : Cultural Considerations for Global Business: Explain the importance of researching the culture of a potential global market before market entry

Develop to address or prevent vicarious trauma : Describe and explain two areas you need to further develop to address or prevent vicarious trauma and explain why you selected each. Based upon the current

User Account

All Pages