Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ACME Analytics indicates that the average age of a consultant is 40 years, EJF Inc. wants to know if the mean age of their consults

image text in transcribed
ACME Analytics indicates that the average age of a consultant is 40 years, EJF Inc. wants to know if the mean age of their consults is representative of the broader population, please select the appropriate analysis (one sample t-test, independent samples t-test or paired samples t-test) and conduct the analysis in Excel. Please explain the results Employee | Age Race Gender Tenure Income Yearly Yearly ID 2015 Sales Sales 2014 2015 Joe 22 Caucasia | Male 1 year $60,000 $200,000 $210,000 n Keylah 34 African- Female 10 years $80,000 $175,000 $170.000 American Ashley 54 Caucasia Female 27 years $150,000 $600,000 $650,000 n Yukiko 27 Asian Female 3 years $70,000 $250,000 $240,000 Marrissa 45 Native- Female 12 years $90,000 $400,000 $350,000 American Zach 36 African- Male 8 years $75,000 $300,000 $320,000 American John 50 Caucasia Male 25 years $130,000 $1,000,00 $1,000,00 n 0 Ruth 62 Caucasia Female 33 years $250,000 $3,500,00 $4,000,00 n Yuta 34 Asian Male 8 years $73,000 $275,000 $300,000 Tyrell 25 African- Male 2 years $63,000 $100,000 $90,000 American Lori 40 Caucasia Female 11 years $82,000 $320,000 $350,000 n Adoette 34 Native- Female 3 years $70,000 $245,000 $250,000 American Mary 29 Caucasia Female 4 years $72,000 $100,000 $150,000 n Dontae 38 African- Male 16 years $100,000 $450,000 $490,000 American Hikaru 42 Asian Male 17 years $105,000 $530,000 $600,000

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

Trigonometry

Authors: David M Kennedy, James Stewart, Lothar Redlin, Saleem Watson

2nd Edition

1285226089, 9781285226088

More Books

Students also viewed these Mathematics questions

Question

Did I choose this value, or did I copy it from someone else?

Answered: 1 week ago

Question

An improvement in the exchange of information in negotiations.

Answered: 1 week ago

Question

1. Effort is important.

Answered: 1 week ago