A sales manager collected data on annual sales for new customer accounts and the number of years of experience for a sample of 10 salespersons. In the Microsoft Excel Online file below you will find a sample of data on years of experience of the salesperson and annual sales. Conduct a regression analysis to explore the relationship between these two variables and then answer the following questions.
Open spreadsheet
Compute b1 and b0 (to 1 decimal).
b1 =____ fill in the blank
b0 =____ fill in the blank
Complete the estimated regression equation (to 1 decimal).
y= ____ + ____x fill in the blank 5x
According to this model, what is the change in annual sales ($1000s) for every year of experience (to 1 decimal)?
____fill in the blank
Compute the coefficient of determination (to 3 decimals). Note: report r2 between 0 and 1.
r2 =____ fill in the blank
What percentage of the variation in annual sales ($1000s) can be explained by the years of experience of the salesperson (to 1 decimal)?
fill in the blank ____ %
A new salesperson joins the team with 8 years of experience. What is the estimated annual sales ($1000s) for the new salesperson (to the nearest whole number)?
$____ fill in the blank
Salesperson Years of Experience Annual Sales ($1000s)
1 2 78
2 4 94
3 4 87
4 4 104
5 5 107
6 9 109
7 9 124
8 10 121
9 10 122
10 14 131
Answers
Answer:
(a) [tex]b_1 =3.4[/tex] and [tex]b_0 = 83.7[/tex]
(b) [tex]y=83.7+3.4 x[/tex]
(c) [tex]r^2 = 0.790[/tex]
(d) [tex]\% Variation = 79.0\%[/tex]
(e) The expected earnings is: $110,900
Step-by-step explanation:
The data for the 10 sales person is as follows:
[tex]\begin{array}{ccc}{Years\ of Experience} & {Annual\ Sales(\$ 1000)} & {Salesperson} & {1} & {1} & {85} & {2} & {3} & {97} & {3} & {3} & {95}& {4} & {5} & {97}& {5} & {7} & {105}& {6} & {8} & {106}& {7} & {10} & {122} & {8} & {10} & {120} & {9} & {12} & {113} & {10} & {12} & {134}\ \end{array}[/tex]
Required
Perform a regression analysis using Microsoft Excel
Note
I added two attachments to this solutionIn the first attachment, I highlighted the step to follow to perform regression analysis. At step 4, ensure that you fill in the input y range and the input x range. The input y range (in this question) is the column for sales person while the input x range is the annual sales Click ok, then Microsoft Excel will perform the analysis for you.
The question will be answered based on the result of the analysis performed by the application (See attachment 2)
See attachment 2 for the result of the analysis (I've highlighted the solution to each question on the attached file)
(a) b1 and b0
[tex]b_1 = 3.372767857[/tex]
[tex]b_1 \approx 3.4[/tex]
[tex]b_0 = 83.65625[/tex]
[tex]b_0 \approx 83.7[/tex]
(b) The estimated regression equation
The equation is of the form:
[tex]y =b_0 + b_1x[/tex]
Where:
[tex]b_1 =3.4[/tex]
[tex]b_0 =83.7[/tex]
So:
[tex]y=83.7+3.4 x[/tex]
(c) The coefficient of determination (r^2)
[tex]r^2 = 0.790361699[/tex]
[tex]r^2 \approx 0.790[/tex]
(d) Percentage of variation
To do this, we simply convert r^2 to percentage
[tex]\% Variation = r^2 * 100\%[/tex]
[tex]\% Variation = 0.790 * 100\%[/tex]
[tex]\% Variation = 79.0\%[/tex]
(e) Expected annual sales of a sales person with 8 years of experience.
Using the regression equation
[tex]y=83.7+3.4 x[/tex]
Where
[tex]x = 8[/tex] --- the years of experience.
So;
[tex]y = 83.7 + 3.4 * 8[/tex]
[tex]y = 83.7 + 27.2[/tex]
[tex]y = 110.9[/tex]
The expected earnings is: $110,900
Related Questions
Which of the following statements is false?
A
Credit cards let you spend unlimited money.
B.
Credit cards have minimum monthly payments.
с
Credit cards give you the chance to build good credit.
D
Credit cards let you spend money that you don't have.
Answers
Answer:
A: Credit Cards let you spend unlimited amount of money.
An organization purchases 10 computers from a manufacturer with lifetimes modeled as exponential variables (mean of 5 years). What is the probability that at least 6 computers are functioning beyond 6 years
Answers
Answer:
0.0482 = 4.82% probability that at least 6 computers are functioning beyond 6 years
Step-by-step explanation:
For each computer, there are only two possible outcomes. Either it works beyond 6 years, or it does not. The probability of a computer working beyong 6 years is independent of any other computes. This means that the binomial probability distribution is used to solve this question.
As the lifetime of a computer is an exponential variable, the probability of a computer working beyond 6 years is found using the exponential distribution.
Binomial probability distribution
The binomial probability is the probability of exactly x successes on n repeated trials, and X can only have two outcomes.
[tex]P(X = x) = C_{n,x}.p^{x}.(1-p)^{n-x}[/tex]
In which [tex]C_{n,x}[/tex] is the number of different combinations of x objects from a set of n elements, given by the following formula.
[tex]C_{n,x} = \frac{n!}{x!(n-x)!}[/tex]
And p is the probability of X happening.
Exponential distribution:
The exponential probability distribution, with mean m, is described by the following equation:
[tex]f(x) = \mu e^{-\mu x}[/tex]
In which [tex]\mu = \frac{1}{m}[/tex] is the decay parameter.
The probability that x is lower or equal to a is given by:
[tex]P(X \leq x) = \int\limits^a_0 {f(x)} \, dx[/tex]
Which has the following solution:
[tex]P(X \leq x) = 1 - e^{-\mu x}[/tex]
The probability of finding a value higher than x is:
[tex]P(X > x) = 1 - P(X \leq x) = 1 - (1 - e^{-\mu x}) = e^{-\mu x}[/tex]
Probability of a computer working beyong 6 years:
Mean of 5 years means that [tex]m = 5, \mu = \frac{1}{5} = 0.2[/tex]
The probability is:
[tex]P(X > 6) = e^{-0.2*6} = 0.3012[/tex]
What is the probability that at least 6 computers are functioning beyond 6 years?
10 computers means that [tex]n = 10[/tex]
0.3012 probability of a computer working beyond 6 years means that [tex]p = 0.3012[/tex]
This probability is:
[tex]P(X \geq 6) = P(X = 6) + P(X = 7) + P(X = 8) + P(X = 9) + P(X = 10)[/tex]
In which
[tex]P(X = x) = C_{n,x}.p^{x}.(1-p)^{n-x}[/tex]
[tex]P(X = 6) = C_{10,6}.(0.3012)^{6}.(0.6988)^{4} = 0.0374[/tex]
[tex]P(X = 7) = C_{10,7}.(0.3012)^{7}.(0.6988)^{3} = 0.0092[/tex]
[tex]P(X = 8) = C_{10,8}.(0.3012)^{8}.(0.6988)^{2} = 0.0015[/tex]
[tex]P(X = 9) = C_{10,9}.(0.3012)^{9}.(0.6988)^{1} = 0.0001[/tex]
[tex]P(X = 10) = C_{10,10}.(0.3012)^{10}.(0.6988)^{0} \approx 0[/tex]
[tex]P(X \geq 6) = P(X = 6) + P(X = 7) + P(X = 8) + P(X = 9) + P(X = 10) = 0.0374 + 0.0092 + 0.0015 + 0.0001 + 0 = 0.0482[/tex]
0.0482 = 4.82% probability that at least 6 computers are functioning beyond 6 years
What is the answer???
Answers
For what angles are sine and cosine the same?
Answers
Answer:
e
Step-by-step explanation:
what is the value of 3 in 728.36
Answers
The length of arc GJ is equivalent to 26π/3 units.
What is place value?Place value can be defined as the value represented by a digit in a number on the basis of its position in the number.
Given is the value of 3 in 728.36.
In 728.36, the digit 3 is at tenths place. The digit 6 is at units place. We can say that the digit 3 is at tenths place in the decimal number 728.36.
Therefore, the digit 3 is at tenths place in the decimal number 728.36.
To solve more questions on place value, visit the link-
https://brainly.com/question/29213222
#SPJ2
Maya keeps her bolts in a large box in her garage. The total number of bolts in the box, f(x), is determined by the number of models (x) that she builds. The graph below shows that this relationship is a linear function. Which of the following would be the largest possible value in the domain of Maya’s function?
4
10
11
12
Answers
Answer:
4
Step-by-step explanation:
The domain of a function consist of all possible values of x that will give us corresponding values of y.
From the graph given, the points plotted indicates on the x-axis that the largest possible value we can have on the x-axis which represents Maya's Domain function is x = 4.
4 is the highest domain of Mayas function.
Find the value of x. Round to the nearest tenth. x=
27 , 34 , 11 ,
Will give brainliest
Answers
Answer:
13.5
Step-by-step explanation:
your teacher wrote all the tools you need down already.
we only need to apply them.
is that really so difficult ?
because of the law of sines we have
sin(27)/11 = sin(34)/x
we can also turn this upside down to simplify the calculation.
11/sin(27) = x/sin(34)
x = 11×sin(34)/sin(27) = 13.549 ≈ 13.5
there, that was all there was to it ...
Determine the amplitude or period as requested. Amplitude of y = cos 5x a (2pi)/5 b 1 d 5
Answers
Answer:
The amplitude is 1
Step-by-step explanation:
Given
The right function is:
[tex]y = \cos(5x + \frac{2}{5}\pi) +5[/tex]
Required
Determine the amplitude
The general cosine function is:
[tex]y = A\cos(k(x + c)) +d[/tex]
Where
[tex]Amplitude = |A|[/tex]
Compare [tex]y = A\cos(k(x + c)) +d[/tex] and [tex]y = \cos(5x + \frac{2}{5}\pi) +5[/tex]
[tex]A = 1[/tex]
So:
[tex]Amplitude = |1|[/tex]
So, we have:
[tex]Amplitude = 1[/tex]
Find the area of the semicircle. Enter the an exact answer in terms of or use 3.14 for and enter your answer as a decimal. PLEASE ANSWER NOW!
Answers
Answer:
6.28 units²
Step-by-step explanation:
The formula for finding the area of a circle:
πr²
We are given r = 2. So,
π(2)²
12.56 units²
However, it is a semicircle. So, only half of this value is needed.
12.56/2 = 6.28 units²
Answer:
area =12.56
Step-by-step explanation:
area of a semicircle=(pi(r)^2)/2
(3.14(2)^2)/2
(3.14(4))/2
12.56/2
6.28
A baseball league finds that the speeds of pitches are normally distributed,
with a mean of 89 mph and a standard deviation of 2.4 mph. One pitch is
thrown at a speed of 83.2 mph. What is the z-score of this pitch? Round your
answer to two decimal places.
A. -2.42
B. -2.72
C. 2.42
D. 2.72
Answers
what is this y=
[tex] \frac{3}{2}x+3 [/tex]
the y=-3
Answers
Answer:
X=-4
Step-by-step explanation:
If you are finding x,
set these two functions equal to each other
3/2x+3=-3
3/2x=-6
x=-4
X = -4 is the answer
Please help I beg you, I will pay too
Do you think standardized testing to measure the effects of the pandemic is “unnecessary or even actively harmful” this year — or, do you think schools need to administer those tests to see where students stand
Answers
Answer:
Read the claim. Schools should stop doing standardized testing. Read the counterclaim. The Department of Education says that teaching students to do well on standardized tests helps to motivate students and keep them focused on important subjects. Read the rebuttal. On the contrary, being forced to focus on testing stresses students and limits the amount of knowledge they can gain. How can the writer revise the rebuttal to make it stronger
A car wash attendant counted the number of cars washed and the total amount of money earned. The company charged the same price for each car washed and earned $165 for 15 cars, $231 for 21 cars, and $275 for 25 cars. Write an equation for the relationship between the number of cars washed, n, and the number of dollars earned, m.
Answers
If you take the different of the money from 21 cars and 25 cars, you get 44 and since 21 and 25 is only a difference of 4, you’ll divide the 44 earned by the 4 cars washed to get $11 per car and then just make sure to use the correct variables
The diagram shows Maha's garden.
AB = 15.3 m.
BC= 13.6m.
AD = 24.0m.
Find the perimeter of the garden.
Answers
Answer:
perimeter = 71.4 m
Step-by-step explanation:
using the Pythagorean theorem:
CD² = 15.3² + (24 - 13.6)² = 234.09 + 108.16 = 342.25
CD = √342.25 = 18.5
perimeter = 24 + 15.3 + 13.6 + 18.5 = 71.4 m
Find the zero of the function f(x)=0.8e^2x -9. Round to the nearest hundredth.
Answers
Answer: x=1.21
Step-by-step explanation:
Given
Function is [tex]f(x)=0.8e^{2x}-9[/tex]
To find the zeroes, equate the function equal to zero
[tex]\Rightarrow 0.8e^{2x}-9=0\\\\\Rightarrow e^{2x}=\dfrac{9}{0.8}\\\Rightarrow e^{2x}=11.25[/tex]
taking natural logarithm both sides
[tex]\Rightarrow \ln (e^{2x})=\ln (11.25)\\\Rightarrow 2x=2.42\\\Rightarrow x=1.21[/tex]
The zero of the equation is 1.21
In the triangle below,
y = [ ? ) cm. Round to the
nearest tenth.
15 cm
х
35
90°
y
Enter
Answers
y ≈ 12.3
Good luck
What is the equation of a line that goes through (2,5) and (-2, 3)?
Answers
Answer:
y = 1/2x+4
Step-by-step explanation:
First find the slope
m= (y2-y1)/(x2-x1)
= (3 - 5)/(-2 -2)
= -2/-4
= 1/2
Using point slope form
y -y1 = m(x-x1) where m is the slope and (x1,y1) is a point on the line
y-5 = 1/2(x-2)
Distribute
y-5 = 1/2x -1
Add 5 to each side
y-5+5 = 1/2x -1+5
y = 1/2x+4
Shun is going to flip a fair coin 450450450 times.
Complete the following statement with the best prediction.
The coin will land tails up...
Choose 1 answer:
Choose 1 answer:
(Choice A)
A
Exactly 175175175 times
(Choice B)
B
Close to 175175175 times but probably not exactly 175175175 times
(Choice C)
C
Exactly 225225225 times
(Choice D)
D
Close to 225225225 times but probably not exactly 225225225 times
Answers
Answer:
c
exactly 225225225 times
Answer:
The answer is- Close to 225225225 times but probably not exactly 225225225 times
Step-by-step explanation:
according to Khan Academy
Which expression is equivalent to j(j)(j)(j)(j)(j)(j)(j)(j)(j)(j)(j)(j)?
o 13'
o 13j
o j13
oj + 13
need help fast pls!
Answers
Answer: j^13
Please give me a brainlist if it’s right
what is the equation for g, which is f(x)=2x+3x-1 reflected across the y-axis
Answers
Find the missing side of each right triangle (((((Pythagorean’s Theorem))))))))
Answers
Answer:
3.87
Step-by-step explanation:
? = a
b = 1
c = 4
a² + b² = c²
a² + 1² = 4²
a² + 1 = 16
a² = 15
a = 3.8729
Rounded to hundredths: 3.87
Find the measure of minor arc QN.
M
0
K
IN
38
Р
Answers
Answer:
142°
Step-by-step explanation:
Minor arc QN = m(MN) + m(QM)
n(MN) = m<MKN = 90° (central angle = measure of intercepted arc)
m(NO) = m<NKO = 38° (measure of intercepted arcs)
m(QM) = 180° - (m(MN) + m(NO)) (half circle)
Substitute
m(QM) = 180° - (90° + 38°)
m(QM) = 52°
✔️Minor arc QN = m(MN) + m(QM)
Substitute
Minor arc QN = 90° + 52° = 142°
Helppppppppppppppppppppppp
Answers
Answer:
32
Step-by-step explanation:
Answer:
113.04 yd³
Step-by-step explanation:
The formula of volume of sphere
[tex] = \frac{4}{3} \pi {r}^{3} [/tex]
The volume of the sphere
[tex] = \frac{4}{3} \times 3.14 \times {3}^{3} [/tex]
[tex] = \frac{339.12}{3} [/tex]
= 113.04 yd³
HELP!! geometry homework
Answers
Answer:
2794 in³
Step-by-step explanation:
Given
base (a) = 17 in
vertical height (h) = 29 in
Now
Volume of the square pyramid
= 1/3 a²h
= 1/3 * 17² * 29
= 2793.7 in³
= 2794 in³
hope it helps :)
Answer:
2794
Step-by-step explanation:
V=s^2 times height over three
17^2 times 29/3
PEMDAS, exponents first
17^2=289
PEMDAS, next up multiplication
289 times 29/3
8381/3 or 2793.7
round to nearest whole number
2794
Which of the following options have the same value as 30% percent of 81?
Answers
Answer:
24.3
Step-by-step explanation:
30% of 81 can be found by converting the percentage into the fraction 0.30 and then multiplying: 0.30(81) = 24.3
please help for 30 points!!
Answers
Answer:
AB = √17 4.1
GH = 4√2 5.7
Step-by-step explanation:
AB = 1²+4²=c²
1+16=c²
17=c²
√17=c
c=4.1
GH = 4²+4²=c²
16+16=c²
32=c²
√32=c
4√2=c
C=5.7
Pls help I'll give brainlest
Answers
Answer:
6
Step-by-step explanation:
a=V⅓=216⅓=6
hope this helped
Answer:
the answer is 6 because on each side there is 36 cubic units meaning you need to multiply 6 by what ever number untill you get to 36 and 6*6=36
Step-by-step explanation:
UwU
The measures of the angles of A ABC are given by the expressions in the table.
Angle
Measure
А
(6x- 1)
B
20°
с
(x + 14)
What are the measures of angles A and C?
Answers
First You add all given angles up to equal 180 to give you x then you plug x into equations
A= 125 degrees
C= 35 degrees
Hey, please could someone help :)
Answers
Step-by-step explanation:
Under 18 tickets: 5062-3484=1578
Total money: 3484*18+1578*12=81648$
100%-85%=15% goes to community projects
So, (15/100)*81648=12247.2 $
3484 tickets are adults tickets, which means that 1578 are under 18 tickets since 5062-3484=1578. Then you multiply 3484 by the price of the adult tickets and 1578 by the price of the under 18 tickets and add them together. 3484*18=62712, and 1578*12=18936. 62712+18936=81648. This means that in total, they made $81,648 in ticket sales. Then you have to find how much went to the community projects. 15% of ticket sales go to the community so $81,648*(0.15) equals $12,247.20
The triangle shown is rotated about line m.
What is the approximate base area of the resulting three-
dimensional figure?
Area of a circle: A = rr?
m
10 cm
8 cm
38 sq. cm
113 sq. cm
201 sq. cm
314 sq. cm
6 cm
Answers
Answer:
B 113
Step-by-step explanation:
on edg
From the information given, the area of the circle is: "113 sq. cm".
What is mean by Circle?The circle is a closed two dimensional figure , in which the set of all points is equidistance from the center.
The formula to find the area of a circle is,
Area = πr².
Now, Using the side as the radius of the circle, we can calculate the area of the base area.
Here,
Radius r = 6
Thus, We get;
A = π x 6²
A = (22/7) x 36
A = 3.14285714286 x 36
A = 113.12
A ≈ 113 square unit.
Hence, The area of the circle is,
⇒ A = 113 sq. cm.
Learn more about the area of a circle visit:
brainly.com/question/14068861
#SPJ7