Question
In: Statistics and Probability
Using the data given below, answer the following questions: X 20 31 50 57 61 62...
- Using the data given below, answer the following questions:
|
X |
20 |
31 |
50 |
57 |
61 |
62 |
72 |
79 |
81 |
88 |
|
y |
25 |
39 |
42 |
45 |
47 |
80 |
81 |
93 |
68 |
99 |
Note: As a way to check your data entry, Âxy = 41600 for this data.
The value of the correlation coefficient, r, is _______________________
The linear regression equation is: y = ________________________________________________ PHOTO (data lists and output)
Briefly discuss whether this line a good fit for the data and why (or why not).
Use your calculator to graph the data and vjg"tgitguukqp"nkpg0"*FqpÓv"hqtigv"vq"¦qqo"vq"{qwt"fcvc0+""
PHOTO (graph)
Solutions
Expert Solution
Dear student, please comment in the case of any doubt and I would love to clarify it
We will be applying the Linear regression model here, it can be done by using the function LINEST(y_value, x_value, TRUE, TRUE) where y_values contain values of y here and x_values have x values.
Select 5 rows and 2 columns and then write the formula in the first cell and after that, press Shift + Ctrl + Enter.
The equation comes out to be-
y = 0.21 + 1.03*x
The correlation comes out to be 0.88, it was calculated using the function CORREL(array1, array2) where array1 is x values and array2 is y values.
orchestra answered 1 year agoRelated Solutions
Given the data set below, use it to answer the following questions: 10, 20, 30, 40,...
Given the data set below, use it to answer the following
questions:
10, 20, 30, 40, 50
a. Find the standard deviation
b. Add 5 to each data set value and find the standard
deviation.
c. Subtract 5 from each value and find the standard
deviation.
d. Multiply by 5 on each value and find the standard
deviation.
e. Divide by 5 on each value and find the standard
deviation.
f. Generalize the results in parts a-e.
Answer the following questions using the data given below. Moviegoer Spending on Snacks (n = 10)...
Answer the following questions using the data given below.
Moviegoer Spending on Snacks (n = 10) Age (X) ($) Spent (Y) 30 6.85
50 10.50 34 5.50 12 10.35 37 10.20 33 10.75 36 7.60 26 10.10 18
12.35 46 8.35 Use Excel to make a scatter plot of the data. Select
the data points, right-click, select Add Trendline, select the
Options tab, and choose Display equation on chart and Display
R-squared value on chart. Picture Click here for the...
Given the following estimated demand equation Answer the following questions “From the data for 50 States...
Given the following estimated demand equation Answer the
following questions
“From the data for 50 States in the United States , the
following Regression Equation was estimated:
Ln C = 5.75 – 1.29 LnP + 0.67 LnY - 0.022LnA -
0.03LnExcT
T- Stats: (0.91)
(1.45) (2.45)
(1.02)
(2.04)
R2 = 0.87;
T- table value at 95%; and 46 degrees of freedom is 1.96.
Where C = Cigarette consumption packs per year
P = real...
Given the following estimated demand equation Answer the following questions “From the data for 50 States...
Given the following estimated demand
equation Answer the following questions
“From the data for 50 States in the
United States for 2015, the following Regression Equation was
estimated:
Ln C =
5.75 – 1.29 LnP + 0.67 LnY - 0.022LnA - 0.03LnExcT
T- Stats:
(0.91)
(1.45)
(2.45)
(1.02)
(2.04)
R2
= 0.87;
T- table value at 95%;
and 46 degrees of freedom is 1.96.
Where C = Cigarette consumption packs
per year
P = real...
answer the following questions using rhe x-y data set below: X: 2, 6, 5, 4, 8,...
answer the following questions using rhe x-y data set below:
X: 2, 6, 5, 4, 8, 4, 1
Y: 18, 51, 43, 32, 65, 34, 7
use the regression equation to predict a value of y when
x=3
. Using the financial statement and data below answer the following questions: Financial Statement Data and...
. Using the financial statement and data below answer the
following questions:
Financial Statement Data and Stock Price Data for
Flextronics
(All data as of fiscal year end; $ in millions)
Income Statement
2012
2013
2014
2015
2016
Revenue
404.3
363.8
424.6
510.7
604.1
Cost of Goods Sold
-188.3
-173.8
-206.2
-246.8
-293.4
Gross profit
216
190
218.4
263.9
310.7
Sales and Marketing
-66.7
-66.4
-82.8
-102.1
-120.8
Administration
-60.6
-59.1
-59.4
-66.4
-78.5
Depreciation & Amortization
-27.3
-27
-34.3...
Using data set E, answer the questions given below. DATA SET E Microprocessor Speed (MHz) and...
Using data set E, answer the questions given below.
DATA SET E Microprocessor Speed (MHz) and
Power Dissipation (watts) (n = 14 chips)
Chip
Speed (MHz)
Power (watts)
1989 Intel 80486
20
3
1993 Pentium
100
10
1997 Pentium II
233
35
1998 Intel Celeron
300
20
1999 Pentium III
600
42
1999 AMD Athlon
600
50
2000 Pentium 4
1300
51
2004 Celeron D
2100...
QUESTION 1 (20 Marks) REQUIRED In view of the information given below, answer the following questions:...
QUESTION 1
REQUIRED
In view of the information given below, answer the following
questions:
1.1 Explain THREE (3) costs or risks to businesses of holding
little or no cash.
1.2 Explain THREE (3) motives for holding cash.
1.3 What advice would you offer financial managers to ensure the
effective of cash?
Complete parts (a) through (h) for the data below. x- 40, 50, 60, 70, 80 y-62,...
Complete parts (a) through (h) for the data below.
x- 40, 50, 60, 70, 80
y-62, 58, 55, 47, 33
B) Find the equation of the line containing the points (50, 58)
and (80, 33)
y=__x+(__)
D) By hand, determine the least-squares regression line
The equation of the least-squares regression line is given
by
ModifyingAbove y with caret equals b 1 x plus b 0y=b1x+b0
where b1 equals r times StartFraction s Subscript y Over s
Subscript x EndFractionb1=r•sysx
is...
Use the following data to answer the questions below:
Use the following data to answer the
questions below: Q
VC
MC
AVC
1
$10
___
___
2
16
___
___
3
20
___
___
4
25
___
___
5
31
___
___
6
38
___
___
7
46
___
___8
55
___
___9
65
___
___ a. Calculate the marginal cost and
average variable cost for each level of production.b. How much would the firm produce if
it could sell its product for...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- CASE STUDY The Alcatel-Lucent Merger—What Went Wrong? It did not take long after the merger for...
- To complete each assignment, you will need to read the case study. Assume that the client...
- Define reliability, failure, and normal operating conditions. Identify and list the various ways to improve reliability.
- How would you use the Consumption-CAPM to explain the small-firm effect? (i.e. firms with small market...
- discusses the importance of international trade to economic growth and development of the courntries. Using facts,...
- An ideal gas is expanded from 5 bars to 1 bar through isentropic(reversible and adiabatic) operation...
- You are the Accountant for Duke Street, Inc. and your boss asks you to provide the...
ADVERTISEMENT