Variables
This is a two-part assignment that will be submitted as one document. You
do not need to include the introduction or conclusion sections. Be sure that
you read the instructions here very carefully before you begin.
Part I. To complete the first part of this assignment, follow these instructions
to locate information that will help you practice ic. With this information,
you will explain assumptions and interpret statistics (F- and R-square).
Steps:
▪ Go to the US Department of Education: College Scoreboard. Then
select Search Field of Study.
▪ In the search bar, type in Public Administration, and then press enter.
▪ Select only Bachelor’s Degree and leave the Location field blank.
(You will have a list of approximately 200 public and private colleges
and universities. From the list of schools, select a minimum of 12
public colleges and universities. Ignore all private colleges and
universities).
▪ Select the Public Administration link under Bachelor’s Degree. (You
will see the Graduation Rate, Average Annual Costs, and Salary After
Completing Field of Study).
▪ Build a table from the information you collected. Ignore any public
college or university that does not provide all three data categories.
Utilizing the software of your choice, use this information to create a
table from the information you collected.
▪ create scatter plots, and
▪ conduct simple linear and multiple least squares regression
analysis.
Once you have completed the above steps, you will:
▪ Report on the simple linear regression scatter plot:
▪ Import the simple linear regression scatter plot into a word
document in APA Style and format.
▪ Import the simple linear regression analysis results in a word
document, in APA style and format.
▪ Explain if any assumptions of simple linear regression were
violated.
▪ Interpret the F-statistic, the R-square statistic, the significance
of the coefficient, t-test, and the significant coefficients.
▪
▪ Report on the multiple regression scatter plot.
▪ Import the multiple regression scatter plot into a word document
in APA style and format.
▪ Import the multiple regression analysis into a word document in
APA style and format.
▪ Explain if any assumptions of multiple-linear regression were
violated.
▪ Interpret the F-statistic, the R-square statistic, the significance
of the coefficient, t-test, and the significant coefficients.
Part II. As in previous units, revisions to the hypothesis and research
questions are necessary. If you feel revisions are needed, go ahead and
make them. If no revisions are needed, justify your decision. Keep in mind
you will be developing a quantitative research proposal.
Your final submitted document must be at least three pages in length. The
title and reference do not apply to the page count You may use the
textbook as one resource and two resources should be from the CSU
Online Library Research Databases.
Adhere to APA Style when constructing this assignment, including in-text
citations and references for all sources that are used. Please note that no
abstract is needed.
Do not do Part II or worry about the page count
WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU
GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class
CLICK HERE TO MAKE YOUR ORDER on Identifying dependent and independent variables and simple linear regression