Share
Explore BrainMass

Excel functions for use in statistics

See attached files.

The questions and solutions are attached for a group of problems, but I don't know how to work them in Excel. All references in the questions are also attached. Please assist with the Excel commands.

Attachments

Solution Preview

See attached files.

The attached Excel has all worked out, including the last in Group 5 where I typed in all the data for you.

The same spreadsheet is attached twice. Once it is zipped up and includes images of the problem side-by-side for comparison. The other is a much smaller file and not ...

Solution Summary

The attached Excel has all problems worked out.

The same spreadsheet is in two versions. Once it is zipped up and includes images of the problem side-by-side for comparison. The other is a much smaller file and not compressed since it contains no images.

The last two questions are in their own spreadsheets: Fresh15.xls and Movies.xls. Between the three spreadsheets, all solutions are in Excel. Be sure to place your cursor in the answer cells to see the Excel formula commands used in each case.

Here are the Excel Commands used in the solutions:

Group 1 #15: NORMDIST()
Group 1 #25: NORMINV()
Group 1 #27: NORMINV() and NORMDIST()
Group 1 #30: NORMINV()
Group 1 #31: NORMDIST()

Group 2 #9: SUM() and MEDIAN()
Group 2 #10: SUM(), VAR(), SQRT(), STDEVP(), and MEDIAN()
Group 2 #11: SUM(), VAR(), and VARP()
Group 2 #12: AVERAGE(), SUM()

Group 3 #9: NORMDIST()
Group 3 #11: NORMDIST()
Group 3 #21: BINOMDIST()

Group 4 #27: BINOMDIST()

Group 5 #9: AVERAGE(), STDEV(), SERIES(), Scatter Plot

Fresh 15: TINV(), SQRT(), STDEV(), COUNT(), SUM()
MOVIES.XLS: Excel Regression Add-In

$2.19