Question: Use the Unit 7 Variable Selection Spreadsheet that your instructor has posted in the Virtual Office to determine which two quantitative variables you will use

Use the Unit 7 Variable Selection Spreadsheet that your instructor has posted in the Virtual Office to determine which two quantitative variables you will use in your analysis. Select a pair of variables that a classmate has not previously selected by putting your name in the first column beside the pair you choose; unless all the variable pairs have already been claimed, then you will put your name in the second column beside the pair you select. Name the pair of variables that were selected for you and describe them (based on what you read in Step 1). Download the dataset, copy the data for these two variables and paste it into a new sheet, which you will attach to your post at the end. Which variable is your independent variable? Which one is your dependent variable? What is your research question? The question should be in the format of "Is there a significant correlation between and ?" Use the Unit 7 Discussion video "Correlation and Regression" in the Unit 7 LiveBinder to help you create a scatterplot (include axis labels) and give the correlation coefficient, r. Discuss any relationship you see from the scatterplot and r value: Does there appear to be a linear or nonlinear relationship? Is the relationship positive or negative? Is the linear relationship weak, moderate, or strong? Next, you will conduct an appropriate hypothesis test. What is the name of the test you will run? What are the Ho and Ha? The discussion video also demonstrated how to conduct the regression analysis in Excel. Insert your Excel regression output in your response using the snipping tool and Insert Image
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
