# Statistics homework help

Statistics homework help.

• There are three parts of the homework.
1. Part I – You must solve manually using calculator
2. Part II – You will need to solve using MS-Excel
3. Part III – You will need to solve using R 3) Your submission would be a single PDF file.
• For Excel part, you will need to include snapshot of your analysis done using excel. Along with the same, please write a short paragraph explaining how you conducted the analysis. If you have been asked follow-up questions based on your analysis, please answer them as well.

Part 1: Questions to be solved manually using calculator:

1. 1 Following tables 1 and 2 were collected by Mr. Biden as a part of gaming business. Mr. Biden knows that covariance associated with Game 1 is given by “H”. In order to decide his strategy for next year, he wants to know correlation and covariance between Customers and Profit with reference to Game 2 in terms of H. Please help Mr. Biden to get the required information.
 Table 1: Game 1 Table 2: Game 2 Customers Profit Customers Profit 10 5 60 30 20 15 90 40 30 20 150 40 40 25 30 10 50 10 120 75

Q.2 Mr. Kumar is a computer operator. He is interested in determining relationship between Input and Output values generated by the computer he is working on. Use simple linear regression to help Mr.
Kumar answer few questions based on the data provided in the below table.

 Input Output 1 4 2 7 3 10 4 13 5 16 6 19
1. Develop a relationship between Input (independent variable) and output (dependent variable) using simple linear regression.
2. Predict the output values for input values 7 and 8. Calculate sum of squared errors (SSE)
3. Calculate Total Sum of Squares (SST).
4. Find the r2 for the model developed in sub question 1

Q.3
Consider the following set of points:

 x1 x2 y 1 1 9 2 0 15 0 1 2
1. Find the least square regression line ?? = ?0 + ?1?1 + ?2?2 from the given data points.
2. Find the residual corresponding to each y
3. Find the Sum of Squared Error (SSE)
4. Find the Total sum of squares (SST)
5. Estimate the value of y given (?1 = 2, ?2 = 3)
6. Find the ?2 of the model

Q.4
Mr. King performed logistic regression for his manufacturing project. The actual observed odd ratio for his project is 3/2. However, his predicted odds ratio is 2/3. Please help Mr. King to calculate the absolute difference between observed probability and estimated/predicted probability.

Q.5
Using the information provided below, convert the problem into logistic regression framework and solve

1. Framework for logistic regression: ln(odds ratio)= ?0 + ?1 ∗independent variable
 Length Number of Positive Cases Number of Negative Cases 4810 47 139 4520 177 241 4400 1087 1183 4370 187 175 4350 397 671 3780 40 14 3660 39 17
1. Find the appropriate equation for the above data. (Hint: You will need to use formula from simple linear regression. But you would need to calculate your Y values based on information provided keeping logistic regression framework in mind).
2. Find estimated probability for length=5000.
3. Based on estimated probability in earlier case, how many total cases (estimate) one needs to gather if he/she wants to get 100 positive cases for length=5000.

Part 2: Questions related to Excel:

1. For the dataset under worksheet “Example 2”, perform simple linear regression using Excel with

Tissue Concentration as an independent variable

1. Based on results, please write down regression line equation
2. Based on results, can intercept have value “-2”? If yes/no, why?
3. What percentage of the total variation of “Math Score” is NOT explained by regression?
1. For the dataset under worksheet “Example 3”, perform multiple linear regression using Excel with Average _fare as a dependent variable
1. Based on results, please write down regression line equation (α = 0.05)
2. Interpret results as in explain what will happen to dependent variable with increase or decrease independent variables. (For this question: ? = 0.1)
2. Wang is a new intern at Magical Analytics company. Her manager, Dr. Chen gave her the below Excel output results. These are results generated by running Excel which is performing simple linear regression on a dataset. Few missing values are represented by letters A-F. Please answer the following question:

1. Please find values for A, B, C, D, E and F.

Part 3 :Questions related to R:

1. For the given data vectors with “SO2_Concentration” and “Recession_Rate”, please fill in the necessary blanks in R code to get the following:
1. Find the correlation between two variables
2. Find the covariance between two variables
3. Apply simple linear regression with “Recession_Rate” as an independent variable
4. Summarize your simple linear regression
5. Find the confidence intervals for simple linear regression model
6. ANOVA for simple linear regression.
7. Based on the results, write down the equation of the regression line. (Terms which are statistically insignificant will have 0 value for their beta values).
9. Find the relationship between multiple R2 and correlation.

What to submit:
Answers of the questions  g, h and i with explanation

1. For the data you are fetching from the website, please fill the necessary blanks in R code to get the following:
1. Fit a multiple linear regression using y (cost) as dependent variable and x1, x2, x3, x4 as independent variables
2. Summarize your multiple linear regression
3. Find the confidence interval for multiple linear regression
4. ANOVA for the multiple linear regression
5. Based on the results, write down the equation of the regression line. (Terms which are statistically insignificant will have 0 value for their beta values).
6. Derive F statistics expressed by summary function using details given by anova table

What to submit:
Answers of the questions  e and f with explanations

1. Ms. Wang is a new intern at Magical Analytics company. Her manager, Dr. Chen gave her the below R output results. These are results generated by running R code which is performing multiple linear regression on a dataset. Please answer the following question:

1. What are number of observations in this dataset?
2. Calculate F statistics for multiple regression model. Please specify the number of degrees of freedom for the numerator and denominator.
3. Which predictors would not contain 0 in their confidence interval? (α = 0.05)
4. If lower end confidence interval value for complaints variable is 0.28016866, then find the confidence interval for intercept.

Statistics homework help

## Why US?

##### 100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

##### Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

##### Original Writing

We complete all papers from scratch. You can get a plagiarism report.

##### Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.