there are two distinct methods of calculating summary or descriptive statistics in Excel: 1) Data Analysis Tool Pack (th

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

there are two distinct methods of calculating summary or descriptive statistics in Excel: 1) Data Analysis Tool Pack (th

Post by answerhappygod »

there are two distinct methods of calculating summary or
descriptive statistics in Excel: 1) Data Analysis Tool Pack (the
descriptive statistics option) and 2) functions in Excel. This
question requires you to use both methods to calculate summary
statistics for the weekly earnings of female workers and male
workers. Tabulate and interpret a set of summary statistics you
should NOT use any hard-wired Excel statistical functions such as
Average, Median, Mode, STDEV etc. Instead, you need to show
step-by-step calculations of the statistics. You are to use the
Excel sort and sum commands, or any other non-statistical commands.
The calculations should be carefully laid out in Excel. Also, with
the second method, you can ignore calculations of Standard Error,
Kurtosis and Skewness.]
please email me at dhirengames @ g mail. com so I can send the
relevant files, thank you.
(ignore the spaces when sending the email)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply