Purchase Solution

Statistical analysis

Not what you're looking for?

Ask Custom Question

Using Excel as your processing tool, work through three simple regression analyses.

1. First run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable and the INTRINSIC job satisfaction column of all data points in the AIU data set as the dependent variable. Create a graph with the trendline displayed. What is the least squares regression line equation? What are the slope and the y-intercept? What is the R-squared value?

2. Next, run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable and the EXTRINSIC job satisfaction column of all data points in the AIU data set as the dependent variable. Create a graph with the trendline displayed. What is the least squares regression line equation? What are the slope and the y-intercept? What is the R-squared value?

3. Next, run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable and the OVERALL job satisfaction column of all data points in the AIU data set as the dependent variable. Create a graph with the trendline displayed. What is the least squares regression line equation? What are the slope and the y-intercept? What is the R-squared value?

4. Finally, make very specific comments and give reasons regarding any similarities or differences in the output results. Which regression produces the strongest correlation coefficient result? Why?

Be sure to provide references in APA format for any resources you may use.

Attachments
Purchase this Solution
Solution Summary

The response address the queries posted in 699 words with references.

Solution Preview

The response address the queries posted in 699 words with references.

//Before writing about the 'Regression Analysis' of the selected variables from the job satisfaction survey of the AIU population, we will write about the different 'Variables' included in the data set. Then, we will provide the regression analysis of the benefits and intrinsic job satisfaction.//

The data set provided by the American Intellectual Union comprise of the job satisfaction survey. The job satisfaction survey is based on the different factors, gender, age, department; and job position, tenure with the company, overall job satisfaction, extrinsic job satisfaction, intrinsic job satisfaction ; also the benefits. The survey comprises of the analysis of different factors for assessing the job satisfaction level of the population. The analysis will focus on the description about the trend line and least square regression line equation. Along with this, the 'R-squared' value will also be described and the best fit output results will be evaluated for the selected variables (Bernstein, 1999).

By considering benefits as the 'independent variable' and intrinsic job satisfaction as the 'dependent variable' on ...

Solution provided by:
Ashish Sharma, MBA (IP)
Education
  • MBA (IP), International Center for Internationa Business
  • BBA, University of Rajasthan
Recent Feedback
  • "Thank You so much! "
  • "Always provide great help, I highly recommend Mr. Sharma over others, thanks again. "
  • "great job. I will need another help from you. "
  • "first class!"
  • "Thank you for your great notes. Will you be willing to help me with one more assignment? "
Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

View More Free Quizzes
Related BrainMass Solutions

  • Statistical Analysis

    324426 Bio-Statistics: Select the Appropriate Statistical Test for Analysis of Hospital Costs Select the appropriate statistical test that allows you to conduct an analysis of the factors affecting hospital costs.

  • Statistical Analysis Procedures

    101112 Statistical Analysis Procedures ?

  • Bio-statistics/ Select the appropriate statistical test

    322531 Bio-statistics/ Select the appropriate statistical test Tables is already done in attachment ... Select the appropriate statistical test that allows you to conduct an analysis of the factors affecting hospital costs.

  • Statistical estimation and regression analysis

    59274 Statistical estimation and regression analysis What is the purpose of statistical estimation? What statistics do you find most useful in regression analysis? Why?

  • Trend Analysis of Walmart

    s=WMT+Historical+Prices Main Elements The analysis will be a Statistical Report that will include the solution data. Be sure to consider a statistical analysis project that applies to a real-life problem or situation.

  • Nonparametric Analyses

    If the variables are qualitative, then we would consider nonparametric statistical analysis. Secondly, if the variables are quantitative, but they do not follow normal distributions, then we would consider nonparametric statistical analysis.

  • A Fictitious Statistical Study

    480321 Fictitious Statistical Study For this activity you will undertake an analysis based on a self-designed fictitious study that utilizes statistical methodologies. You will first develop a fictitious problem to examine, it can be anything.

  • HR Statistical data analysis and evaluation

    339029 HR Statistical data analysis and evaluation: mean, median, deviation, t-test, ANOVA Identify the types of processes and analyses used in HR that use data analysis and evaluation.

  • What statistical procedures were used for this particular article?

    Purpose of analysis Statistical procedure Statistic Result Probability (p) Example Purpose of analysis Statistical procedure Statistic Result Probability (p) Difference between the age of male and female students t-test t 3.75 p

  • Overgeneralization and basic statistics

    These two different measuring procedures can lead to quantitative differences to represent their effort investment, and therefore, affect your statistical analysis.

View More Related Solutions