Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 28, 2024

use Excel to stepwise calculate summary statistics. Here you would estimate a whole range of statistics to measure central tendency, variation, and the shape of

use Excel to stepwise calculate summary statistics. Here you would estimate a whole range of statistics to measure central tendency, variation, and the shape of the data

These calculations should be carefully laid out in Excel and should NOT use any hard-wired Excel statistical functions e.g. Average, Median, Mode, STDEV, VAR, QUARTILE, etc.

You can use the Excel sort command, the sum command, and any other non-statistical excel commands.

gender age wage degree married

Male 36 3.009027 Yes Yes

Male 61 6.521739 No No

Female 25 9.2 No No

Female 22 10 No No

Male 23 10.56 No No

Female 27 13.5 Yes No

Female 27 14.58333 No Yes

Male 21 16.26667 No No

Male 21 16.42857 No No

Female 31 17.5 No No

Male 27 18 No No

Female 41 18.2 Yes Yes

Female 26 18.34211 No Yes

Female 31 19.18 No No

Female 23 19.18182 No No

Female 28 19.67442 No Yes

Female 63 19.90625 No No

Male 24 19.98333 No No

Male 52 20 No No

Female 27 20.18421 Yes No

Female 27 20.83333 No Yes

Female 49 21 No Yes

Male 47 21.4 No No

Female 43 21.4186 Yes No

Female 31 21.48889 Yes No

Female 27 21.5 Yes Yes

Male 27 21.81818 No No

Female 60 21.90476 No No

Male 52 22 No No

Male 22 22.275 No No

Male 22 22.5 No No

Male 60 22.63158 No No

Female 41 22.64151 No Yes

Male 39 23.08 No No

Female 39 24.56 No Yes

Female 48 24.57143 No Yes

Male 30 24.95 No Yes

Male 22 25 No No

Male 26 25.56667 Yes No

Male 22 25.66667 No No

Male 32 26 No No

Female 46 26.24 No Yes

Female 47 26.31579 No No

Male 31 26.90476 No Yes

Male 60 27.16667 No Yes

Female 53 27.16667 No Yes

Female 25 27.34043 Yes No

Female 35 27.625 No No

Male 63 28 No Yes

Male 28 28 Yes No

Female 42 28.33333 Yes No

Male 44 28.33333 No No

Female 28 28.62 Yes No

Male 24 28.775 No No

Male 27 28.85 No No

Female 26 28.92105 Yes No

Female 59 29.08333 No Yes

Male 23 29.30909 No No

Male 40 29.69767 Yes Yes

Male 22 31 Yes No

Female 50 31.11111 No Yes

Female 65 31.125 Yes No

Male 28 31.2093 Yes No

Male 30 31.42857 Yes No

Female 37 31.66667 No Yes

Male 32 32.34375 No No

Female 25 32.42105 No No

Male 32 32.5 No Yes

Female 51 33.18605 No Yes

Male 35 33.33333 No Yes

Male 27 33.4 Yes Yes

Male 38 34.375 No No

Female 64 34.87273 No No

Male 26 34.92 Yes No

Female 34 37.09302 No Yes

Male 27 37.44737 No Yes

Male 37 37.5 No No

Female 33 37.6 Yes Yes

Male 23 38.15789 No No

Female 30 38.35 No No

Male 37 38.35 No No

Female 41 38.46154 No Yes

Female 27 38.8 No No

Male 26 38.85185 No No

Male 35 39 Yes Yes

Female 29 39.5 No No

Female 55 39.85 Yes No

Male 42 39.95 No Yes

Female 22 40 No No

Male 30 40.04546 No No

Female 61 41.66667 Yes No

Female 41 41.83636 Yes No

Male 29 42.44186 No No

Female 59 42.51351 No Yes

Male 37 43.02222 No No

Male 29 43.15 No No

Male 46 43.16 Yes No

Female 32 43.34286 Yes No

Male 50 43.85965 No Yes

Male 30 44.6 No Yes

Male 33 44.75555 No No

Female 33 44.86666 Yes No

Male 40 46.02 No No

Male 44 46.02 Yes Yes

Male 26 46.42105 Yes No

Female 58 47.95 Yes Yes

Female 31 48.075 No No

Female 36 48.2 Yes No

Female 46 48.9 Yes No

Male 32 49.02222 Yes No

Male 55 50.92857 Yes No

Male 46 52.94 Yes No

Male 37 56.25 Yes No

Female 43 56.4 No Yes

Male 64 57.525 No Yes

Male 36 61.38 Yes Yes

Male 36 61.5 No No

Male 49 61.72093 No Yes

Male 31 68.94736 Yes Yes

Female 60 70 No Yes

Male 42 70.21277 Yes No

Male 35 70.83334 Yes No

Male 31 73.1 No Yes

Male 38 73.64 Yes Yes

Male 38 78.26 Yes No

Female 43 79.68571 No Yes

Male 38 79.88889 Yes No

Male 63 80 Yes No

Male 56 87.5 No Yes

Male 64 91.17647 No Yes

Male 31 100 No No

Male 53 100 Yes Yes

Male 44 100.5814 No No

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

Step: 3

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

Calculus Single Variable

Authors: Howard Anton, Irl C Bivens, Stephen Davis

11th Edition

1118885686, 9781118885680

More Books

Students also viewed these Mathematics questions

Question

★★★★★

Explain the definition of total disability that is found in a typical waiver-of-premium provision.

Answered: 1 week ago

Question

★★★★★

Consider the final model fitted to the osteoporosis data in Chapter 7, Section 7.2. (a) When this model is fitted to these data, how many dimensions does each of the following have: (i) the data...

Answered: 1 week ago

Question

★★★★★

Using the Exerbike data set, (a) determine the mean and standard deviation of calories burned per minute (Cals/M) for 2019. (b) determine the mean and standard deviation of calories burned per minute...

Answered: 1 week ago

Question

★★★★★

Brangelina Adoption Agencys general ledger shows a cash balance of $4,593. The balance of cash in the March-end bank statement is $7,345. A review of the bank statement reveals the following...

Answered: 1 week ago

Question

★★★★★

Miller Toy Company manufactures a plastic swimming pool at its Westwood Plant. The plant has been experiencing problems as shown by its June contribution format income statement below: Flexible...

Answered: 1 week ago

Question

★★★★★

Observe that if B, B1 and 7 are given, then each Y; is a gaussian: Y| (30, 31, 7) ~N (Bo + BXi, 1/7). Therefore, the likelihood function of the vector (Y,...,Y) given (B0, B1, 7) is of the form...

Answered: 1 week ago

Question

★★★★★

Can you help me answer this mathematical questions related to data management? Thank you so much!!! IS MMW Module 7 Post Task 2nd SE X _> Course Modules: Mathematics in X + X C A...

Answered: 1 week ago

Question

★★★★★

Instructions: 1. You must write the title of the case and the bibliographic record. 2. Mention the parties involved in the case, duly identified as plaintiffs or defendants, etc. 3. What is the main...

Answered: 1 week ago

Question

★★★★★

1.Two equal-sized newspapers have an overlap circulation of 10% (10% of the subscribers subscribe to both newspapers). Advertisers are willing to pay $8 to advertise in one newspaper but only $15 to...

Answered: 1 week ago

Question

★★★★★

Newells Decision to Downsize: An Ethical Dilemma A particular issue in business ethics is: What exactly does the term ethics mean? Various writers have described ethics as rules that govern behavior,...

Answered: 1 week ago

Question

★★★★★

5. DURATION OF INVERSE FLOATERS Assume that LIBOR rates are risk free. Suppose you have a 10 year note that pays a quarterly coupon of (10% - 2 3mo LIBOR), divided by 4 since this is a quarterly...

Answered: 1 week ago

Question

★★★★★

1. Discuss what you think is meant by the following statements: a) Splitting an egg into half to get two chickens. b) We cannot study time by taking apart a clock.

Answered: 1 week ago

Question

★★★★★

5. Give some examples of hidden knowledge.

Answered: 1 week ago

Question

★★★★★

3. Try to clarify how you think when you are going to write a note aimed at influencing the leader of the department. Remember, it is not what you think, but how you think that should be clarified....

Answered: 1 week ago

Previous Question Next Question

gender	age	wage	degree	married
Male	36	3.009027	Yes	Yes
Male	61	6.521739	No	No
Female	25	9.2	No	No
Female	22	10	No	No
Male	23	10.56	No	No
Female	27	13.5	Yes	No
Female	27	14.58333	No	Yes
Male	21	16.26667	No	No
Male	21	16.42857	No	No
Female	31	17.5	No	No
Male	27	18	No	No
Female	41	18.2	Yes	Yes
Female	26	18.34211	No	Yes
Female	31	19.18	No	No
Female	23	19.18182	No	No
Female	28	19.67442	No	Yes
Female	63	19.90625	No	No
Male	24	19.98333	No	No
Male	52	20	No	No
Female	27	20.18421	Yes	No
Female	27	20.83333	No	Yes
Female	49	21	No	Yes
Male	47	21.4	No	No
Female	43	21.4186	Yes	No
Female	31	21.48889	Yes	No
Female	27	21.5	Yes	Yes
Male	27	21.81818	No	No
Female	60	21.90476	No	No
Male	52	22	No	No
Male	22	22.275	No	No
Male	22	22.5	No	No
Male	60	22.63158	No	No
Female	41	22.64151	No	Yes
Male	39	23.08	No	No
Female	39	24.56	No	Yes
Female	48	24.57143	No	Yes
Male	30	24.95	No	Yes
Male	22	25	No	No
Male	26	25.56667	Yes	No
Male	22	25.66667	No	No
Male	32	26	No	No
Female	46	26.24	No	Yes
Female	47	26.31579	No	No
Male	31	26.90476	No	Yes
Male	60	27.16667	No	Yes
Female	53	27.16667	No	Yes
Female	25	27.34043	Yes	No
Female	35	27.625	No	No
Male	63	28	No	Yes
Male	28	28	Yes	No
Female	42	28.33333	Yes	No
Male	44	28.33333	No	No
Female	28	28.62	Yes	No
Male	24	28.775	No	No
Male	27	28.85	No	No
Female	26	28.92105	Yes	No
Female	59	29.08333	No	Yes
Male	23	29.30909	No	No
Male	40	29.69767	Yes	Yes
Male	22	31	Yes	No
Female	50	31.11111	No	Yes
Female	65	31.125	Yes	No
Male	28	31.2093	Yes	No
Male	30	31.42857	Yes	No
Female	37	31.66667	No	Yes
Male	32	32.34375	No	No
Female	25	32.42105	No	No
Male	32	32.5	No	Yes
Female	51	33.18605	No	Yes
Male	35	33.33333	No	Yes
Male	27	33.4	Yes	Yes
Male	38	34.375	No	No
Female	64	34.87273	No	No
Male	26	34.92	Yes	No
Female	34	37.09302	No	Yes
Male	27	37.44737	No	Yes
Male	37	37.5	No	No
Female	33	37.6	Yes	Yes
Male	23	38.15789	No	No
Female	30	38.35	No	No
Male	37	38.35	No	No
Female	41	38.46154	No	Yes
Female	27	38.8	No	No
Male	26	38.85185	No	No
Male	35	39	Yes	Yes
Female	29	39.5	No	No
Female	55	39.85	Yes	No
Male	42	39.95	No	Yes
Female	22	40	No	No
Male	30	40.04546	No	No
Female	61	41.66667	Yes	No
Female	41	41.83636	Yes	No
Male	29	42.44186	No	No
Female	59	42.51351	No	Yes
Male	37	43.02222	No	No
Male	29	43.15	No	No
Male	46	43.16	Yes	No
Female	32	43.34286	Yes	No
Male	50	43.85965	No	Yes
Male	30	44.6	No	Yes
Male	33	44.75555	No	No
Female	33	44.86666	Yes	No
Male	40	46.02	No	No
Male	44	46.02	Yes	Yes
Male	26	46.42105	Yes	No
Female	58	47.95	Yes	Yes
Female	31	48.075	No	No
Female	36	48.2	Yes	No
Female	46	48.9	Yes	No
Male	32	49.02222	Yes	No
Male	55	50.92857	Yes	No
Male	46	52.94	Yes	No
Male	37	56.25	Yes	No
Female	43	56.4	No	Yes
Male	64	57.525	No	Yes
Male	36	61.38	Yes	Yes
Male	36	61.5	No	No
Male	49	61.72093	No	Yes
Male	31	68.94736	Yes	Yes
Female	60	70	No	Yes
Male	42	70.21277	Yes	No
Male	35	70.83334	Yes	No
Male	31	73.1	No	Yes
Male	38	73.64	Yes	Yes
Male	38	78.26	Yes	No
Female	43	79.68571	No	Yes
Male	38	79.88889	Yes	No
Male	63	80	Yes	No
Male	56	87.5	No	Yes
Male	64	91.17647	No	Yes
Male	31	100	No	No
Male	53	100	Yes	Yes
Male	44	100.5814	No	No