Class Survey Data File
Building Your MR Model:
Selecting Your X-variables*
Ã¢â‚¬Â¢ Y-variable: HAPPY* (The Happy data is in the last column of data in the Class Survey Data File.)
Ã¢â‚¬Â¢ X-variables: Select 3 (no more, no less),
one of which must be 2-category nominal-level data.
Ã¢â‚¬Â¢ To include your selected 2-category nominal data in your model, see the short video, Ã¢â‚¬Å“Creating a Dummy
Variable in ExcelÃ¢â‚¬Â in the Assignment area of this chapter.
*The queries for all responses are included on the Ã¢â‚¬Å“Survey QuestionsÃ¢â‚¬Â sheet of the Class Survey File.
pfront Planning on Selection of Variables
Survey data includes external factors, demographic data, personality traits, emotional measures,
and spiritual/religious dimensions.
Ã¢â‚¬Â¢ Think about what a good model might be. Have an overarching idea for your model. Then support that
idea by the X-variables you select.
Ã¢â‚¬Â¢ Doing the above will make your statement much easier to write and more than a sterile, accomplishment
listing of stats knowledge, because you will have specific context through which to interpret your results.
We create the model to test our thinking/reasoning (as with the C-13 Correlation & C-13 SLR assignments)
Running Your Data
Copy & Paste
your variables form the Class Survey Data File onto a new sheet. Place the X-variables in
adjacent columns with the Y-variable (Happy) in a column before/after.
Ã¢â€”Â In Excel, running MR involves the same steps as running SLR (C-13 SLR assignment).
and complete the Popup Box as before:
Ã¢â€”â€¹ Input Y Range: the range of cells containing your Y-variables data
Ã¢â€”â€¹ Input X Range: the range of cells containing your X-variable data
Ã¢â€”â€¹ Click on Labels
Ã¢â€”â€¹ Output Range: input any cell that is not already occupied
click on New Worksheet Ply
Ã¢â€”â€¹ Note: Excel auto-sets
alpha at .05
(95% confidence level). You can use this setting.
Create a (Multi)collinearity Matrix
Return to your selected X-variables & Y-variable.
, and then select
Input Range: Highlight (Select) the cell range for all the data: Xs, Y, and Labels
in the first row
and input a cell outside the range of your data. Click
the second set of upper and lower 95% boundaries (the last 2 columns) in the Anova table.
Do NOT turn in the raw data. Ã¢â€”Â Do NOT turn in any residuals. Ã¢â€”Â Do NOT turn in any graphs.
Copy and Paste the correlation matrix below your multiple regression output tables.
Interpreting Your Results
I am not looking for one correct model or a useful model. So, there is no reason to run multiple models.
What is important is your demonstration of creating a model, the articulation of your reasoning for your model/X-variables, your statement of how the results support and/or do not support your thinking, and any specific explanation and conclusion regarding your particular outcome. Your writing should display critical thinking and insight into your understanding of multiple regression within the given context
1 Possible Structure:
Ã¢â€”â€¹ Intro: WhatÃ¢â‚¬â„¢s your model and reasoning for X-variables selection.
Ã¢â€”â€¹ Body: Analyze the data within the context of your model/reasoning.
Ã¢â€”â€¹ Conclusion: Summary? Possible Changes? Possible Next Step? Etc.
General Writing Tips
(That you know but may forget while focused on the statistics):
Let the reader know your dummy variable code, either in the statement or tables.
Specificity is better than generalities.
Ã¢â€”â€¹ Conciseness is better than verbosity.
Ã¢â€”â€¹ Paragraphs show organization of thought. Use them (or write as well as
Set cells to 3 decimals and clean up tables, including but not necessarily limited to specifically identifying your output, widening/shortening column widths and/or merging cells so all words are fully legible, etc.
C 13_Submission Form_MR_1-Way Anova
Ã¢â‚¬Â¢ Response must be in
work and in
Ã¢â‚¬Â¢ You are not getting a degree in data entry or Excel, so whether a score moves upwards or downwards
is determined to the degree to which the statement is a well-executed, blended expression of subject
matter context and statistics.
Ã¢â‚¬Â¢ Use 11pt/12pt font and do not exceed 1 page.
IMPORTANT: Submission Forms must be kept as a Word document (.doc or .docx) or PDF (.pdf) or if
Page 2: Attach a second page containing your Multiple Regression Output (in this order):
needed try as an image (jpeg, jpg, or png). Other formats do not open on my end.
Submission Form: Order of Materials
Ã¢â‚¬Â¢ Page 1: Written Statement
Ã¢â€”â€¹ Summary Output Table
Ã¢â€”â€¹ Anova Table
Ã¢â€”â€¹ Coefficient Table
Ã¢â€”â€¹ (Multi)collinearity Matrix
For reading pages and pages of directions this semester and for working to follow them, Thank You!
Click or tap here to enter text.
Click or tap here to enter text .
Multiple Regression Statement:
WARNING: Do Not Extend this Text Box Beyond the First Page!
Purchase answer to see full