Math 1070 Excel Project Part I and 2

Reminder: The goal of this project is to get you comfortable with the use of Excel; to that end, any calculations, even minor ones, not done using Excel, could result in point deductions or possibly a grade of ‘0’ for this assignment. (You should have absolutely no need for a calculator on this assignment). Cells are formatted to show 2 decimal places … but you should type formulas (not numbers) Data Set The data in the columns below are counts of the number of words spoken in a day by male (M) and female (F) subjects in independent simple random samples of men and women ranging in age from 18 to 29. Parts 1-3 will relate to one or both of the data in these columns: Part 1: Descriptive Statistics a. In the spaces below, provide the mean, variance, standard deviation and range for the sample of the number of words spoken in a day by males and females: b. Provide the 5-Number Summary for the sample data of the number of words spoken in a day by males and females in the boxes below: Part 2: Hypothesis Test for Means (1-Sample) Test the claim that the mean number of words spoken by women (in between the ages of 18 to 29) is less than 16000 per day. Use a significance level of 0.05:

 

CLICK HERE TO ORDER A SIMILAR PAPER

We pride ourselves in writing quality essays

CLICK HERE TO CONTACT US

Lets Start Working

Plagiarism Free

We use anti-plagiarism software to ensure you get high-quality, unique papers. Besides, our writers have a zero plagiarism mentality

On Time Delivery

Your essay will be delivered strictly within the deadline.  If you have an urgent order, we can do it!

Money Back Guarantee

We offer warranty service, including free revisions, and a right to request a refund incase your expectations are not met!

THE BEST PAPER WRITER HELPER

Our Advantage

  • Say “NO” to plagiarism – FREE plagiarism report as an addition to your paper
  • The lowest prices that fit excellent quality
  • Authorship – you are the one who possesses the paper. We DO NOT re-sale or re-use any of them.

OUR PAPER WRITER HELPER GOODIES

Our Freebies

  • Free Cover Page
  • Free Revisions
  • Free Reference Page
  • Free 24/7 support

Pin It on Pinterest

Share This