Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 07, 2024

Regression Month Spend Sales 1000 9914 Sales 4000 40487 180000 5000 54324 160000 4500 50044 140000 3000 34719 D DO V O UT A W

Regression
Month Spend Sales 1000 9914 Sales 4000 40487 180000 5000 54324 160000 4500 50044 140000 3000 34719 D DO V O UT A W N 120000 4000 42551 100000 9000 94871 80000 11000 118914 60000 15000 158484 400 00 10 12000 131348 20000 11 7000 78504 12 3000 36284 2000 4000 6000 8000 100 00 12000 140 00 16000 The Regression Equation (Y=mx +b)= Sales=slope times Spend(x) + Intercept (b) Month Spend Sales Sales (Y) = Intercept + Slope Spend (X) Equation Result Difference From Actual 1000 9914 9914 = 1383.471 + 10.62219546 * 1000 12005.67 2091.67 4000 40487 40487 = 1383.471 + 10.62219546 * 4000 43872.25 3385.25 5000 54324 54324 = 1383.471 + 10.62219546 * 5000 54494.45 170.45 4500 50044 50044 = 1383.471 + 10.62219546 * 4500 49183.35 -860.65 3000 34719 34719 = 1383.471 + 10.62219546 * 3000 33250.06 -1468.94 6 DO V O UT A W N 4000 42551 42551 = 1383.471 + 10.62219546 4000 43872.25 1321.25 9000 94871 94871 = 1383.471 + 10.62219546 * 9000 96983.23 2112.23 11000 118914 118914 = 1383.471 + 10.62219546 11000 118227.62 -686.38 15000 158484 158484 = 1383.471 + 10.62219546 * 15000 160716.40 2232.40 10 12000 131348 131348 = 1383.471 + 10.62219546 * 12000 128849.82 -2498.18 11 7000 78504 78504 = 1383.471 + 10.62219546 * 7000 75738.84 -2765.16 12 3000 36284 36284 = 1383.471 + 10.62219546 * 3000 33250.06 -3033.94 AVERAGE 6541.667 70870.33 Difference SUM 0.00 RegressionDataPlot Regression Output ANOVAdataOutput ChiSquare ClusterAnalysis Equation +SUMMARY OUTPUT W N Regression Statistics Multiple R 0.998832 5 R Square 0.997666 6 Adjusted R Square 0.997432 Standard Error 2313.361 8 Observations 12 10 ANOVA 11 af SS MS F Significance F 12 Regression 1 2.29E+10 2.29E+10 4274.232 1.7067E-14 Scientific Notation: Move the decimal point 14 spaces to the left resulting .0000 13 Zeros 13 Residual 10 53516375 5351637 Total 11 2.29E+10 15 16 Coefficientsandard Erro t Stat P-value Lower 95% Upper 95% ower 95.0upper 95.0% 17 Intercept 1383.471 1255.24 1.102156 0.296212 1413.378591 4180.321 -1413.38 4180.321 18 Spend 10.6222 0.162475 65.37761 1.718-14 10.2601797 10.98421 10.26018 10.98421 19 20 21 22 23 24 25 26 27 28 29 30 31 RegressionDataPlot Regression Output ANOVAdataOutput ChiSquare ClusterAnalysis Equation +

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access to Expert-Tailored 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

Graphical Approach To College Algebra

Authors: John E Hornsby, Margaret L Lial, Gary K Rockswold

6th Edition

0321900766, 9780321900760

More Books

Students also viewed these Mathematics questions

Question

★★★★★

What is the anhydride for each of the following acids: (a) H2SO4 (b) HClO3 (c) HNO2 (d) H2CO3 (e) H3PO4?

Answered: 1 week ago

Question

★★★★★

110. How could your college or university use the concepts in the balanced scorecard? List two possible performance measures that would be relevant to a college or university, for each of the...

Answered: 1 week ago

Question

★★★★★

Time Management Making to-do lists and schedules saves time, but it also takes time. Do you think the time spent on to-do lists and schedules is worth it? How could to-do lists and schedules save you...

Answered: 1 week ago

Question

★★★★★

The average rent in a city is $1,500 per month with a standard deviation of $250. Assume rent follows the normal distribution. Use the empirical rule for normal distributions to answer the following...

Answered: 1 week ago

Question

★★★★★

Kegglers Supply is a merchandiser of three different products. The companys February 28 inventories are footwear, 19,000 units; sports equipment, 78,000 units; and apparel, 49,000 units. Management...

Answered: 1 week ago

Question

★★★★★

In a PowerPoint presentation, provide the following slides Cover Page (in speaker notes, provide an introduction of the purpose of the presentation). Product and Price: Choose an existing product or...

Answered: 1 week ago

Question

★★★★★

You're about to deliver a sales pitch to a potential new client, and discover you don't have the sales presentation on your computer. The only person you know that has it is your colleague Emily,...

Answered: 1 week ago

Question

★★★★★

Which of the given roadmaps suggested in the PI Program ensures that countries have a "learning healthcare system"? Group of answer choices Supportive Payment and Regulatory Environment >...

Answered: 1 week ago

Question

★★★★★

Crane Corporation has the following account balances at December 31, 2023: Common Shares Subscribed $267,000 Common Shares 318,000 Subscriptions Receivable 79,000 Retained Earnings 1,359,000...

Answered: 1 week ago

Question

★★★★★

Here is my verilog code not sure why it won't compile Module ASCII27Seg (input [7:0] AsciiCode, output red [6:0] HexSeg); always @(') begin $display("AsciiCode=%b", AsciiCode);...

Answered: 1 week ago

Question

★★★★★

Problem 04-11\ Suppose that the ingredients required to bring a slice of pizza to market and their respective costs are as listed in the table:\ \\\\table[[Ingredients,Cost],[Paper plate,2...

Answered: 1 week ago

Question

★★★★★

3.3 Describe the impact that HRtechnology has on the role of the HR professional and the resulting three major changes to the role of HR.

Answered: 1 week ago

Question

★★★★★

3. How has the workplace failed at securing equal opportunities or wages for women?

Answered: 1 week ago

Question

★★★★★

2. Why do we need legislation to protect women in the workplace?

Answered: 1 week ago

Previous Question Next Question