Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Two data sets are provided in this week's content: Social Climbers.xlsx and Artsy Lawsuit.xslx. Use these data sets to perform the following tasks within the

Two data sets are provided in this week's content: Social Climbers.xlsx and Artsy Lawsuit.xslx. Use these data sets to perform the following tasks within the spreadsheets:

Social Climbers

  • Compare the data to determine where relationships may exist. For example, you may ask if there is a relationship between education and income levels. Perform at least four different data comparisons.
  • Provide an explanation based on your comparison results. Where do relationships exist and where do they not exist, according to the data?

Artsy Lawsuit

  • The story behind these data comes from a discrimination lawsuit filed, accusing the Artsy company of improper hiring processes and employment pay between men and women. Your task is to use these data to determine if the plaintiffs have a valid or strong case, which would then be presented in court to a jury.
  • Use basic statistical analysis to compare the data.

In both of these data sets, you may choose to use the tools below or any others you feel are appropriate to tell the story and interpret the data. Not all tests are applicable for all data sets. It depends on the types of data and what you want to know:

  • Mean, median, mode
  • Quartiles
  • Pivot tables
  • Regression
  • T-tests
  • Time series
  • Graphs, plots

Submit your results and explanations within the spreadsheets

Here are the datasets in the links below:

https://docs.google.com/spreadsheets/d/1A2alvnX6FpGbrcghNNwpaCE1pKbh304m/edit?usp=sharing&ouid=112078824222075368589&rtpof=true&sd=true

https://docs.google.com/spreadsheets/d/1t5uciRMrkBcga67TsshbISvX8sOlGWHD/edit?usp=sharing&ouid=112078824222075368589&rtpof=true&sd=true

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A First Course in Differential Equations with Modeling Applications

Authors: Dennis G. Zill

11th edition

1305965728, 978-1305965720

More Books

Students also viewed these Mathematics questions

Question

Write a paper research on "Yahoo Hack"

Answered: 1 week ago