Question: A.6. You would like to quantify the relationship between demand and number of placed advertisements using a linear regression model (y = ax + b).

A.6. You would like to quantify the relationship

A.6. You would like to quantify the relationship between demand and number of placed advertisements using a linear regression model (y = ax + b). Historical data about the demand and number of placed ads are presented in the following Excel 26 July 2021 OPS910 Remote Study Mode WG Trimester 2, 2021 Page 2 of 6 B 2 spreadsheet. Which command and cells range should be used to get the value of b? (5 marks) a) SLOPE(A2:A8, B2:38) b) INTERCEPT(A2:A8, B2:38) 1 Demand Number of Ads 202 20 c) SLOPE(B2:B8, A2:A8) 194 19 d) INTERCEPT(B2:B8, A2:A8) 178 17 e) INTERCEPT(A1:A8, B1:B8) 189 215 21 201 20 192 19 3 4 5 18 6 7 8

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Question 1. You would like to quantify the relationship between demand and number of placed advertisements using a linear regression model (y = ax + b). Historical data about the demand and number of...

Mikaela sells homemade pies to many local cafes in Wollongong. She keeps a record of the sales of homemade pies to help her with demand forecasting. The price of a single pie is $4.80. Mikaela has...

2.Each weekMikaela prints handouts to advertise her homemade pies. She has noticed that when more handouts are printed, more pies are sold. She would like to quantify the relationship between sales...

Chapter 151. The manager of the Carpet City outlet needs to make an accurate forecast of the demand for SoftShag carpet (its biggest seller). If the manager does not order enough carpet from the...

Carpet City Month 1 2 3 4 5 6 7 8 9 3 mos moving average Weighted 3 mos moving Demand for Soft Shag Carpet (1,000 yd.) forecast average forecast 10 9 8 9 10 12 14 11 Please apply weights stated in...

The registrar at State University believes that decreases in the number of freshman applications that have been experienced are directly related to tuition increases. They have collected the...

Set Student Name: 1. Describe the relationship between two variables that have a correlation coefficient value: a. Near -1 b. Near 0 c. Near 1 2. Data was collected where a weightlifter was asked to...

Exhibit: CFA Candidates. Thirty three percent of the CFA candidates have a degree ineconomics (CFA refers to the Chartered Financial Analyst, aprofessional designation that measures the competence of...

A process engineer of a refinery wants to purchase a new reactor for the process. He wants to replace the old reactor with the similar type of reactor available in the market. In order to purchase...

Which of the following is not a concern with using amortized cost to value for assets and liabilities Group of answer choices Firm portfolio risk can be obscured All of these are concerns with using...

What is an example of constructive feedback? provide reference