Show me how to post my homework

Question

Submitted by cor.ja on Mon, 2013-09-09 19:46

due on Fri, 2013-09-13 19:44

answered 2 time(s)

Hand shake with Jan V: Complete ($10.00 paid)

Hand shake with Bestwriterfor...: Complete ($6.00 paid)

Hand shake with jam007: In progress

cor.ja is willing to pay $20.00

# 1.Using the Excel Analysis ToolPak function Descriptive Statistics, generate descriptive statistics for the salary data. Which variables does this function not work properly for, even though we have some generated results?

Attachments:

Answer

Submitted by xoon on Tue, 2014-02-04 07:28

price: $15.00

## UPDATED 100% correct answer A+++++++++++++++++++TUTORIAL GUARANTEED PERFECT PLAGIARISM FREE WORK PERFECT CALCULATIONS

body preview (0 words)

file1.xlsx preview (523 words)

# Sheet1

xxxxxxxxxxxx | Sal | Compa | xxx | Age | EES | xx | x | xxxxx | Deg | Gen1 | Gr | Mean xxxxxx salary | Mean xxxx salary | xxxx xxxxx | xxxx compa | xxxxxx |

- - - more text follows - - -

Try it before you buy it |

Answer

Answer rating (rated one time)

## Excel Analysis - Describing the data

body preview (0 words)

file1.xlsx preview (1559 words)

# xx xxxxxxxxxxx xxxxx for xxxxxx

xxxxxxxxxxxxxxxxxxx1. Using xxx Excel Analysis xxxxxxx function descriptive statistics, xxxxxxxx xxxxxxxxxxx statistics xxx the salary data. | |||

Which xxxxxxxxx does this xxxxxxxx not xxxx properly xxxx xxxx though we have xxxx xxxxx xxxxxxxxx xxxxxxxx | |||

xxx | |||

Mean | xxxxx | ||

xxxxxxxx Error | 2.72 | ||

xxxxxx | xxxxx | ||

Mode | 24.00 | ||

Standard Deviation | xxxxx | ||

xxxxxx xxxxxxxx | 368.69 | ||

Kurtosis | -1.45 | ||

xxxxxxxx | xxxx | ||

Range | xxxxx | ||

xxxxxxx | xxxxx | ||

Maximum | xxxxx | ||

Sum | 2,250.00 | ||

xxxxx | 50.00 | ||

xxxxxxxxxx Level(95.0%) | xxxx | Confidence level xx xxx xxxxxxx | xxxxxxxxxxxx |

Confidence level x xxx xxxxx the formula xxxxxxxxxx is different |

# xx F - desc xxxx & x - Fx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx2. xxxx xxx data by Gen xx xxx 1 xxxxx xxxxx and xxxxxxxx and find xxx mean and standard xxxxxxxxx for each gender xxx the following variables: | |||||||||

sal, xxxxxx age, xx xxx raise. | xxx the descriptive stats xxxxxxxx xxx one gender xxx the Fx xxxxxxxxx (average xxx xxxxxx for the xxxxxx | ||||||||

xxxxxxx | |||||||||

xxx | Compa | xxx | SR | Raise | |||||

xxxx | 38.00 | xxxx | xxxx | Mean | xxxxx | Mean | xxxx | xxxx | xxxx |

xxxxxxxx Error | xxxx | xxxxxxxx Error | 0.01 | Standard Error | xxxx | xxxxxxxx xxxxx | xxxx | Standard xxxxx | xxxx |

Median | xxxxx | xxxxxx | 1.04 | xxxxxx | 32.00 | Median | xxxx | xxxxxx | xxxx |

Mode | 24.00 | xxxx | xxxx | xxxx | 32.00 | Mode | xxxx | xxxx | 5.70 |

xxxxxxxx Deviation | xxxxx | xxxxxxxx Deviation | 0.07 | Standard xxxxxxxxx | xxxx | xxxxxxxx xxxxxxxxx | 4.91 | Standard xxxxxxxxx | xxxx |

Sample xxxxxxxx | xxxxxx | xxxxxx xxxxxxxx | xxxx | xxxxxx Variance | 47.34 | Sample Variance | 24.08 | xxxxxx |

- - - more text follows - - -

Try it before you buy it |