Posted: September 13th, 2017

Assignment-supply Chain Management

Paper, Order, or Assignment Requirements

 

There are two parts in this assignment. EXCEL AND ANSWER QUESTION.—-You guy need to finish there two parts .———–please see the attachments. If you have any question. please contact me .

 

Using the Homework 6 data set in Angel and the Excel Homework 6 Tutorial or any other sources, answer the questions below. This portion of the homework must be attached afterthe  non-Excel portion of Homework 6.  All pages of Homework6 and Excel Homework6  must be stapled together. All of the answers below must be in one Word document.

 

Terms:

 

Batting Average (BA)–number of hits/number of at-bats

 

On Base Percentage (OBP) – number of times a player gets on base/number of plate appearances

 

Problem:  We would like to see if there is a relationship between the Batting Average (BA) of players in the National League Central with the On Base Percentage (OBP) of the players. If we conclude there is a relationship, then we can use Batting Average to predict On Base Percentage.

 

1. Make a scatterplot of Batting Average (BA) and On Base Percentage (OBP). BA will be your independent variable and OBP will be your dependent variable.Copy/paste (or screenshot) the scatterplot into your homework document. Resize it so it does not take an entire page.  Write a statement on what kind of relationship you see, if any. (.1 for scatterplot, .1 for statement)

 

2. Using Data Analysis in Excel, find the correlation coefficient for BA and OBP. Copy/paste (or screenshot) the correlation matrix into your homework document.  Write down an interpretation of the value of the correlation coefficient r.  This question cannot be done on a Mac without using the webapp.  (.1 for correlation matrix, .1 for interpretation)

 

(Questions 1-2 can be completed after Lecture 27.)

 

3. Use Data Analysis to run a regression of BA (independent variable) and OBP(dependent variable). Copy/paste (or screenshot) the output into your Word document.This question cannot be done on a Mac without using the webapp.  (.2)

 

4. Find the sample standard deviation of both BAand OBP.Copy/paste (or screenshot) these standard deviations into your homework document.(You must include both the formula and the value in order to get credit.) Then, using the value of r found in Question 2, hand calculate b₁ and write an interpretation of the slope (beginning with the phrase “On average…”).  Does the slope you calculated by hand equal the slope found in the output from Question 3?  (.1 forcalculation of b₁, .1 for interpretation)

 

5. Using the regression output from Question 3, write the regression equation. (.1)

 

6. What On Base Percentage would you predict if the Batting Averagewas.265? (.1)

 

7. Is Batting Average a significant predictor of On Base Percentage? Why or why not?Alpha for this problem is .05.  (.1 for answer, .1 for why)

 

8. What is the value of R-Square? Interpret the value.  (.1 for value, .1 for interpretation)

 

(Questions 3-8 can be completed after Lecture 28.)

1. Write down the symbols of the correlation coefficient (population and sample), what the correlation coefficient tells us, the boundaries of the correlation coefficient, and what each extreme signifies.

 

2. Write down the symbols of the coefficient of determination (population and sample), what the coefficient of determination tells us, the boundaries of the coefficient of determination, and what each extreme signifies.

 

(Questions 1-2 can be completed after Lecture 27.)

 

3. Write down the symbol for standard error of the estimate, what the standard error of the estimate measures, the boundaries of the standard error of the estimate, and what each extreme signifies.

 

4. Write down the symbols of the regression coefficients (population and sample), the boundaries of the regression coefficients, and what the slope regression coefficient tells us.

 

5. Data is collected from each state on average teacher salary and average spending per student. The standard deviation of teacher salary is $6,690.  The standard deviation of spending per pupil is $1,690.  The correlation is .84.  If we are predicting teacher salary from spending per student, compute the regression coefficient.  Using the phrase given in class (On average, …), explain in words what this slope means.  Does this regression coefficient make sense?

 

6. List what we are concluding if we accept the null in a regression problem (p. 179 in the course packet). Then list what we are concluding if we reject the null in a regression problem.You must list all the statements presented in the slide in class in order to get credit.

 

7. Write a scenario for a simple regression problem. You must include what the two variables are, stating which one is x and which one is y.  Remember, y must be quantitative.Do not use the scenarios that are included in the course packet.  If you base your idea off of another source, you must state the source.

 

(Questions 3-7 can be completed after Lecture 28.)

 

8. What can R²_adj do if we add another variable to a regression equation? What can R² do if we add another variable?

 

(Question 8 can be completed after Lecture 30.)