Explore BrainMass
Share

Microsoft Excel Commands

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

I need to know how to do this in EXCEL.. Thank you

The question below appears in the attached file as well. You may find it easier to read in the attachment.

Given the following population data: 1,2,4,5,8,9,12, and the lists of all samples of size 2 and 5:
Samples of n=2 -xbar
1,2--1.5
1,4--2.5
1,5--3
1,8----------------------4.5
1,9----------------------5
1,12---------------------6.5
2,4----------------------3
2,5----------------------3.5
2,8----------------------5
2.9----------------------5.5
2,12---------------------7
4,5----------------------4.5
4,8----------------------6
4.9----------------------6.5
4,12---------------------8
5,8----------------------6.5
5,9----------------------7
5,12---------------------8.5
8,9----------------------8.5
8.12---------------------10
9.12---------------------10.5

For population
s = ?
m = ?

For n = 2
sxbar = ?
mxbar = ?

For n = 5
sxbar = ?
mxbar = ?

Samples of n=5----------------xbar

1,2,4,5,8----------------------4
1,2,4,5,9----------------------4.2
1,2,4,5,12---------------------4.6
1,2,4,8,9----------------------4.8
1,2,4,8,12---------------------5.4
1,2,4,9,12---------------------5.6
1,2,5,8,9----------------------5
1,2,5,8,12---------------------5.6
1,2,5,9,12---------------------5.8
1,2,8,9,12---------------------6.4
1,4,5,8,9----------------------5.4
1,4,5,8,12---------------------6
1,4,5,9,12---------------------6.2
1,4,8,9,12---------------------6.8
1,5,8,9,12---------------------7
2,4,5,8,9----------------------5.6
2,4,5,8,12---------------------6.2
2,4,5,9,12---------------------6.4
2,5,8,9,12---------------------7.2
4,5,8,9,12---------------------7.6
2,4,8,9,12---------------------7

a) Use Excel to find the six ? values above.

b) Consider the three values of mean and the three values of standard deviation in a). Verify (mathematically) that the Central Limit Theorem applies using the formulas:
µ = µxbar and σxbar = σ / √n

c) Why are your answers from a) and b) slightly off?

© BrainMass Inc. brainmass.com October 24, 2018, 5:18 pm ad1c9bdddf
https://brainmass.com/statistics/standard-deviation/microsoft-excel-commands-6868

Attachments

$2.19
See Also This Related BrainMass Solution

Calculation and Microsoft Excel Charts of Financial Ratios

Consider the attached LuluLemon Case Study and Compute the following ratios:

a. Profitability Ratios
-Gross profit margin
-Operating profit margin
-Net profit margin
-Return on total Assets
-Return on stockholder's equity
b. Liquidity Ratios
-Current ratio
-Working capital
c. Leverage Ratios
-Debt to assets
-Long-term debt to capital
d. Activity Ratios
-Inventory turnover
-Average collection period
e. Internal cash flow
NOTE: Compute sample ratios for all of the years presented in the sample case, in order to assess how strong is the firm financially. Use the ratio calculations on pages C-61-C-62. Use Excel in Microsoft Office to create tables and figures to present your ratio analysis, along with graphs (figures) to track trends in the financial performance of the organization.

View Full Posting Details