Step 1: Create a scatter plot

Select the two columns and create a scatte plot.
The column with the explanatory variable  x  should be on the left and the column with the response variable y on the right.
Make sure your explanatory variable is on the horizontal axis.
Add a main title and axis titles.
Edit the range of the axes if the data appears “zoomed out” or odd on your plot. Add a trendline and R^2 to the plot.

STEP 2: OBTAIN THE TABLE OF COEFFICIENTS AND RESIDUAL PLOT

Use your option’s question of interest to state the null and alternative hypotheses
Use data analysis toolpak to run a regression analysis
Be sure to put the y variable first then the x variable.
Include column names (labels) when selecting your data so you to see the explanatory variable name in the output!
Select labels.
Select the residual and residual plot options.
Save your table and residual plot for your post.
Ways to show your work:
Take a screenshot of your excel workbook. Only the work part not the entire screen.

Use the math formula button in Canvas.
Take a screenshot of handwritten work on a tablet.
Neatly hand-write your formulas on paper take a picture with your phone and upload the image within your post. Image needs to .jpeg. (please no words/sentences)

STEP 3: EXPLAIN YOUR ANALYSIS AND SUBMIT YOUR ORIGINAL POST

USE THE “ORIGINAL POST – OUTLINE & PROMPTS” TO CREATE YOUR ORIGINAL POST
Use the title “Week 9 Data Analysis”
Use the same headers as listed below (e.g., “State and Visualize” “Estimating the Relationship”) in your post.
Answer each question/prompt in the bulleted list below each heading in your post.
For the math related questions, please show your work or excel functions you used to find your answers.
ORIGINAL POST – OUTLINE & PROMPTS
Week 9 Data Analysis
STATE AND VISUALIZE

Which option did you choose? What question are you trying to answer with your analysis?

Paste your scatterplot with title, axis labels, trend line and R^2.
In context, describe the relationship using strength, direction and form.
LSRL AND ASSESSING FIT
GIVE THE MODEL IN THE FORM
PASTE THE RESIDUAL PLOT FROM EXCEL
TO ASSESS IF THE ASSUMPTIONS FOR REGRESSION ARE REASONABLE, EVALUATE WHETHER THE RESIDUALS HAVE ANY PATTERN VIOLATIONS. EXPLAIN YOUR REASONING FOR WHETHER THE ASSUMPTIONS ARE OR ARE NOT REASONABLE.
TESTING THE RELATIONSHIP
Paste the table of coefficients from excel.
ESTIMATING PARAMETERS
Interpret the slope using the point estimate and 95% confidence interval from excel. Include context and practical insights or plausible implications from the results of the data.
CONCLUDE

Write a conclusion describing the results. Use alpha = 0.05.
Provide a statement in terms of the alternative hypothesis.
State whether (or not) to reject the null.
State the test statistic, degrees of freedom and p-value.

Last Completed Projects