Purchase Solution

Mean, SD, Scatter Plot, Histogram, Correlation and Regression

Not what you're looking for?

Ask Custom Question

I need hep in manipulating data from a class survey. I need help in preparing an excel worksheet using the ages and guessed income columns (see attached table).
1. For each variable, get the summary statistics using the tools, data analysis
2. For each variable, get the mean and the standard deviation using the paste function.
3. For each variable, draw a histogram. Put appropriate labels on the histogram.
4. Using age as the x variable and guess income as the y variable, draw a scatterplot. Put appropriate labels on the scatterplot.
5. Find the linear regression line. Draw it on the scatterplot and label it with the proper equation.
6. Find the correlation coefficient, r. Also find r2

Attachments
Purchase this Solution
Solution Summary

This solution is comprised of a detailed explanation of 6 questions given in the attachment. This solution mainly discussed 6 questions and all the analysis was performed using excel and its add ins "Data Analysis Tool Pack". Full interpretation and output is provided with labeling. The solution provides the interpretation of results in wherever needed.

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.

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.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Regression model for crime rate

    , sd=23.5 Prec2: mean=33.5, sd=14.1 correlation for week and Prec1=.98 correlation for week and Prec2=.93 Please see the attachment Assignment #3 You have been hired as a data analyst for the Philadelphia Police Department.

  • Analysis of GEYSER Data

    The solution contains scatter diagram, boxplot, histogram, stem and leaf plot, Slope, intercept, correlation, residual, r square, coefficient of determination, regression coefficients and confidence interval with interpretations.

  • Residual analysis for regression

    Use a stem-and-leaf chart or a histogram to verify that the distribution of the residuals is approximately normal. f. Plot the residuals computed in Part E in a scatter diagram with the residuals on the Y-axis and the ? values on the X-axis.

  • Short description type Questions - Regression

    33433 Regression Analysis-Short Essay type A: What is the significance of the error term in the regression equation? B: What does zero correlation tell you? C: How would you use a histogram to chart residuals? What would this tell you?

  • Descriptive Statistics & Correlation Coefficient

    Compute summary statistics of the two variables and plot the data and comment of the relationship between midterm and final scores. 2. Compute the correlation coefficient, r, between midterm and final. Interpret your findings.

  • Solve question on scatter plot, relationship, outlier, causality

    624368 Solve question on scatter plot, relationship, outlier, causality Hello, Please I want to answer these problems. Please help me thinks. Problem 1) Look at the scatter plot below. Does it demonstrate a positive or negative correlation?

  • Basic Statistics Test 1

    Draw the graph of the regression line on the same plot as the scatter diagram above.

  • Regression analysis for oxygen consumption in R.

    scatterplot.matrix(~AGE+MAXPULSE+OXY+RUNPULSE+RUNTIME+WEIGHT, reg.line=lm, smooth=TRUE, span=0.5, diagonal = 'histogram', data=fitness) #Scatter Plot matrix cor(fitness[,c("MAXPULSE","RUNPULSE","RUNTIME","WEIGHT")], use="complete.obs") #Correlation

  • Advanced regression analysis problem with hypothesis testing

    Use a stem-and-leaf chart or a histogram to verify that the distribution of the residuals is approximately normal. g. Plot the residuals computed in part (f) in a scatter diagram with the residuals on the Y-axis and the Y' values on the X-axis.

View More Related Solutions