Excel correlation on the internet

Assignment Help Basic Statistics
Reference no: EM132908809

Data Analysis: Survey There are many guides to excel correlation on the internet. A good resource is: https://www.ablebits.com/office-addins-blog/2019/01/23/correlation-excel-coefficient-matrix-graph/#find-correlation-coefficient

BEFORE DOING ANYTHING, DOWNLOAD THE DATA

Fully answer the following questions:

1. Number of people in each gender category

2. What was the range of the self-esteem score totals?

3. What was the average self-esteem score?

4. What was the correlation (using Pearson) of time spent on Instagram and self-esteem total scores?

a. How strong is this correlation (in words)?

5. What was the correlation (using Pearson) of age and time spent on Instagram?

a. How strong is this correlation (in words)?

b. In this correlation, what is the IV and what is the DV?

6. Are there any outliers in the self-esteem total score?

a. If so, which participant and what was the score?

7. make scatterplot of time spent on Instagram and self-esteem total scores. Copy and paste it below:

Reference no: EM132908809

Questions Cloud

Discuss how wireless bridges and repeaters : Discuss how wireless bridges and repeaters can expand functionality of WLANs and how wireless controllers can simplify the management of WLANs.
What the opportunity cost associated with the order is : What the opportunity cost associated with this order is? The normal unit sales price per unit is $165. A special order from a foreign company has been received.
Explain how ieee 802.11g enhances 802.11b networks : Explain how IEEE 802.11g enhances 802.11b networks and how 802.11n functions in both the 2.4 GHz and 5 GHz bands.
Which is true if a company can accept a special order : Which of the following is true if a company can accept a special order without affecting its regular sales and is within plant capacity?
Excel correlation on the internet : 1. Number of people in each gender category 2. What was the range of the self-esteem score totals?
Inevitable actions resulting from security violations : The objective of this discussion is to map out the response to security violations and how to plan for the inevitable actions resulting from security violations
Which statements is correct about the children : Which statements is correct about the children? Jayden aged 14, and Katrina aged 20, who both live at home, as well as Kathy who is 23
Benefits of participatory decision making : What are the benefits of participatory decision making and under what conditions is it most likely to succeed?
What is likely to be the best way for david to sav : Based on the information, what is likely to be the best way for David to save the additional $15,000 he needs for his house deposit?

Reviews

Write a Review

Basic Statistics Questions & Answers

  Which of the four methods would you recommend

Acknowledging that some bias is inevitable when information is required on such short notice, which of the four methods would you recommend that the television station use to get the information it desires? Explain.

  Describing normal approximation to binomial

A multiple-choice examination consists of 90 questions, each having possible choices a, b, c, d, and e. Approximate the probability that a student will get at least 21 answers correct if she randomly guesses at each answer.

  Explain why number can be described wit normal model

The number of smokers among 120 randomly selected students will vary from group to group. Explain why that number can be described wit a normal model.

  What is confidence interval for their mean rating next year

For the quarterback in part (b), what is the 95% prediction interval for his passer rating next year?- For quarterbacks similar to the one in part (b), what is the 95% confidence interval for their mean rating next year?

  Discuss effect of offering the alternative medicine coverage

A medical insurance company wants to know whether the proportion of its customers requiring a hospital stay during a year will decrease if it provides coverage.

  Compare the lifetimes of two brands of penlight batteries

Using the appropriate statistical table, what is the most accurate statement that can be made about the p-value for the test?

  What is the mean and standard deviation of the population

a) What is the mean and standard deviation of the population that this mean is drawn from?

  What is the company free cash flow for year

What is the company's free cash flow for year 1 of this project?

  Confidence interval for the population percentage

1. Suppose Subway has carried out the study, using the sample size determined in that exer- cise, and 27.5% of the franchisees say they are pleased with their relationship with Subway. Construct and interpret the 95% confidence interval for the po..

  Employee with the same qualifications

A researcher wonders whether males get paid more, on average, than females at a large firm. She interviews 50 employees and collects data

  If we select three transistors without replacement find the

a bag contains ten transistors of those transistors three are defective. if at random we select two transistorsa find

  Sample is the number of defective computer

An example of a paired sample is the number of defective computer chips of a particular type from two different manufacturers. True or False?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd