Homework Answers
Ans. let the average weekly commute time (X) and Rainfall (Y)
Ans. 1 sample covariance of commute time and rainfall is 37.83
Ans.2 the correlation between commute time and rainfall is 0.88
Ans. 3. There is a highly positive relationship between commute time and rainfall as the correlation indicated the high positive correlation between commute time and rainfall.
Add Answer to:
Question 2 Use the data to answer the following questions. You may use excel or your...
Graph a scatterplot with the below data – Use Excel to do your scatterplot – You...
Graph a scatterplot with the below data – Use Excel to do your scatterplot – You will want to show your x and y data in the graph and the points on the graph. Label the graph with a Title and label the x and y axis titles: A) Paste the Excel graph below B) Describe what the graph tells you about the data – how do you interpret the data from the graph in terms of what it means?...
2. Given the data in the table below, answer questions a) 40 e) rainfall (mm) (runoff...
2. Given the data in the table below, answer questions a) 40 e) rainfall (mm) (runoff (mm) 0 0 0 0 O 0 0 0 0 150 200 a) create a scatter plot using these data b) determine the linear regression equation and correlation coeficient include details from the method you used to find the equation: Excel Geodebra, or open office file image of graphing calculator or manual calculations () is this a positive or negative correlation? is ita weak...
Question Use the probability distribution given in the table below to answer the following questions Joint...
Question Use the probability distribution given in the table below to answer the following questions Joint Distribution of Weather Conditions and Commuting Times Rain (X 0) No Rain (X 1) Total Long commute (Y 0) Short commute (Y 1) 0.26 0.13 0.39 0.58 0.03 0.61 Total 0.84 0.16 1.00 Compute the mean of Y E (Y) (Round your response to two decimal places) Compute the mean of X E (X) (Round your response to two decimal places) Compute the variance...
For this and the next 4 questions: Please use the following data to answer the questions...
For this and the next 4 questions: Please use the following data to answer the questions that follow. You may copy over the data to Excel and use spreadsheet functions to perform the required analyses. 1. Calculate the covariance between the Market and Stock A. 2. Calculate the COVARIANCE BETWEEN STOCK B AND MARKET. 3. What is the VARIANCE OF STOCK A? 4. What is the STANDARD DEVIATION OF THE MARKET? Year Market Stock A Stock B 1 -0.10 -0.17...
Use only the Excel functions (no calculator). I need to see all Excel formulas to give...
Use only the Excel functions (no calculator). I need to see all
Excel formulas to give you a full credit. Give answers to the 4th
decimal place.
1. (Sheet #1) (10 points) Use the following categorical
frequency distribution to answer each problem. a. (4 pts) Create a
pie chart and pareto chart. b. (3 pts) Add two more columns:
Relative Frequency (rf) and Cumulative Relative Frequency (crf).
Calculate rf and crf. c. (1 pt.) Find a mean. d. (1 pt.)...
Use the Excel Template and the table of prices and dividends below to answer the next...
Use the Excel Template and the table of prices and dividends below to answer the next seven questions: Kellogg Ticker = K S&P 500 Month Dividend Price Price Jan-17 72.71 2278.87 Feb-17 74.07 2363.64 Mar-17 0.52 72.61 2362.72 Apr-17 71 2384.2 May-17 0.52 71.6 2411.8 Jun-17 69.46 2423.41 Jul-17 68 2470.3 Aug-17 0.54 65.46 2471.65 Sep-17 62.37 2519.36 Oct-17 62.53 2575.26 Nov-17 0.54 66.16 2584.84 Dec-17 67.98 2673.61 Jan-18 68.11 2823.81 Feb-18 66.2 2713.83 Mar-18 0.54 65.01 2640.87 Apr-18 58.9...
Let's use Excel to explore the benefits of diversification. Download weekly adjusted closing price data for...
Let's use Excel to explore the benefits of diversification. Download weekly adjusted closing price data for AutoZone (AZO), Lockheed Martin (LMT), FedEx (FDX), Harley Davidson (HOG) and McDonald's (MCD) between 3 January 2012 and 31 Dec 2012. Use the weekly prices to compute weekly returns and then compute the covariance matrix of returns using the Excel function COVARIANCE.S (you can compute variances with COVARIANCE.S or with VARIANCE.S). Suppose you form an equally-weighted portfolio of HOG and FDX. What is the...
please answer it quikly this quizz has time frame Topic Task 11: Regression and Correlation Data...
please answer it quikly this quizz has time frame
Topic Task 11: Regression and Correlation Data Sheet This data and record sheet is required for you to complete the online Topic Task. Please print this sheet BEFORE you attempt to open the Topic Task 11. You will need this information in front of you when doing the task. You will also need a pencil/pen and your calculator Do not clear the data from your calculator between questions, as you will...
You may need to use the appropriate appendix table or technology to answer this question. The...
You may need to use the appropriate appendix table or technology to answer this question. The state of California has a mean annual rainfall of 22 inches, whereas the state of New York has a mean annual rainfall of 42 inches. Assume that the standard deviation for both states is 4 inches. A sample of 35 years of rainfall for California and a sample of 46 years of rainfall for New York has been taken. (a) Show the probability distribution...
Height vs Weight - Erroneous Data: You will need to use software to answer these questions....
Height vs Weight - Erroneous Data: You will
need to use software to answer these questions.
Below is the scatterplot, regression line, and corresponding data
for the height and weight of 11 randomly selected adults. You
should notice something odd about the last entry.
index
height (x)
weight (y)
inches
pounds
1
60
120
2
72
200
3
65
130
4
72
205
5
67
180
6
69
180
7
68
193
8
69
195
9
61
115
10...
2. Given the data in the table below, answer questions a) 40 e) rainfall (mm) (runoff (mm) 0 0 0 0 O 0 0 0 0 150 200 a) create a scatter plot using these data b) determine the linear regression equation and correlation coeficient include details from the method you used to find the equation: Excel Geodebra, or open office file image of graphing calculator or manual calculations () is this a positive or negative correlation? is ita weak...
Question Use the probability distribution given in the table below to answer the following questions Joint Distribution of Weather Conditions and Commuting Times Rain (X 0) No Rain (X 1) Total Long commute (Y 0) Short commute (Y 1) 0.26 0.13 0.39 0.58 0.03 0.61 Total 0.84 0.16 1.00 Compute the mean of Y E (Y) (Round your response to two decimal places) Compute the mean of X E (X) (Round your response to two decimal places) Compute the variance...
Use only the Excel functions (no calculator). I need to see all
Excel formulas to give you a full credit. Give answers to the 4th
decimal place.
1. (Sheet #1) (10 points) Use the following categorical
frequency distribution to answer each problem. a. (4 pts) Create a
pie chart and pareto chart. b. (3 pts) Add two more columns:
Relative Frequency (rf) and Cumulative Relative Frequency (crf).
Calculate rf and crf. c. (1 pt.) Find a mean. d. (1 pt.)...
please answer it quikly this quizz has time frame
Topic Task 11: Regression and Correlation Data Sheet This data and record sheet is required for you to complete the online Topic Task. Please print this sheet BEFORE you attempt to open the Topic Task 11. You will need this information in front of you when doing the task. You will also need a pencil/pen and your calculator Do not clear the data from your calculator between questions, as you will...
You may need to use the appropriate appendix table or technology to answer this question. The state of California has a mean annual rainfall of 22 inches, whereas the state of New York has a mean annual rainfall of 42 inches. Assume that the standard deviation for both states is 4 inches. A sample of 35 years of rainfall for California and a sample of 46 years of rainfall for New York has been taken. (a) Show the probability distribution...
Height vs Weight - Erroneous Data: You will
need to use software to answer these questions.
Below is the scatterplot, regression line, and corresponding data
for the height and weight of 11 randomly selected adults. You
should notice something odd about the last entry.
index
height (x)
weight (y)
inches
pounds
1
60
120
2
72
200
3
65
130
4
72
205
5
67
180
6
69
180
7
68
193
8
69
195
9
61
115
10...
Most questions answered within 3 hours.
-
What is the quoted price of a bond that has 8 years until
maturity? The face...
asked 1 minute ago -
Leave thourough feedback for this comment please.
A project management should posses the following communication
skills:...
asked 4 minutes ago -
An instructor's reference to a basketball player's defensive
performance as "outstanding" is an example of __________...
asked 4 minutes ago -
There are 3 models that generate 3 below predicted values for
CAD
Model1: $1.00
Model2: $1.112...
asked 9 minutes ago -
Please note this is a question for my midterm so answer
seriously and make sure it...
asked 14 minutes ago -
Conduct a search of "the difference between marketing strategy
and tactics" and scan the results. Select...
asked 18 minutes ago -
what could be done to increase the likelihood of transfer of
training if the work environment...
asked 20 minutes ago -
Consider the following argument: It’s too hot or it’s too cold.
If it’s too cold, I’ll...
asked 20 minutes ago -
Steve's Specialties, Inc. paid its dividend yesterday, which as
$ 3.00. The dividend has been growing...
asked 36 minutes ago -
We are trying to decide a warehouse location to minimize our
costs of moving supplies to...
asked 36 minutes ago -
Create a SWOT Analyst diagram on topic Disaster Recovery Plan
for an commercial business.
asked 35 minutes ago -
How do we make sure that our professional judgment as an auditor
is "free" from bias?
asked 53 minutes ago