Fit the following two curves to these data: linear (Y 5 a 1 bX) and power (Y 5 aXb). Which equation best fits the data? b.    Interpret the best-fitting equation. c.    Using the best-fitting equation, predict sales during a month in which $60,000 is spent on advertising.

Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter5: Inverse, Exponential, And Logarithmic Functions
Section5.5: Properties Of Logarithms
Problem 68E
icon
Related questions
Question

35.    The file P13_35.xlsx contains the amount of money spent advertising a product (in thousands of dollars) and the number of units sold (in millions) for eight months. a. Assume that the only factor influencing monthly sales is advertising. Fit the following two curves to these data: linear (Y 5 a 1 bX) and power (Y 5 aXb). Which equation best fits the data? b.    Interpret the best-fitting equation. c.    Using the best-fitting equation, predict sales during a month in which $60,000 is spent on advertising.  (Note that the data from P13_35.xlsx is already in the excel sheet).

D28
1
2
3
4
5
6
Paste
7
A
Month
1
2
3
4
5
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
6
7
8
Calibri
V
BI U H
x ✓ fx
B
Advertising
$1,000
$2,000
$3,000
$20,000
$30,000
$50,000
$80,000
$100,000
C
Units Sold
4,000,000
4,800,000
5,000,000
7,500,000
8,000,000
9,000,000
9,900,000
10,200,000
V 11
V
D
Α' Α΄
Av
E
F
Transcribed Image Text:D28 1 2 3 4 5 6 Paste 7 A Month 1 2 3 4 5 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 6 7 8 Calibri V BI U H x ✓ fx B Advertising $1,000 $2,000 $3,000 $20,000 $30,000 $50,000 $80,000 $100,000 C Units Sold 4,000,000 4,800,000 5,000,000 7,500,000 8,000,000 9,000,000 9,900,000 10,200,000 V 11 V D Α' Α΄ Av E F
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Similar questions
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Trigonometry (MindTap Course List)
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781337278461
Author:
Ron Larson
Publisher:
Cengage Learning
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Functions and Change: A Modeling Approach to Coll…
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning