Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Data analysis descriptive statistics excel mac

23/11/2021 Client: muhammad11 Deadline: 2 Day

ANALYZING MEAN

INTRODUCTION: Two indispensable statistical decision-making tools for a single

parameter are

(i) Confidence intervals

(ii) Hypothesis tests to investigate theories about parameters.

KNOWN SIGMA

CONFIDENCE INTERVALS

As an introduction, let’s follow Example 8.4 in your text.

image1.png image2.png

Begin a new worksheet and generate 40 random integers the range 0 to 9 in column A. Use the Random Number Generation tool of Excel and then use the INT (integer) function to transform to integers in the range 0 to 9:

Choose: Data > Data Analysis > Random Number Generation > OK

Enter: Number of Variables: 1

Number of Random Numbers: 40

Select: Distribution: Uniform

Enter: Parameters, Between 0 and 10

Output Range: B1 > OK

Enter: in cell A1: =INT(B1)

Click and drag: lower right corner to cell A40

To see the mean, standard deviation and maximum and minimum values for the data set use: Select: Data > Data Analysis > Descriptive Statistics > OK

Enter input and output range as appropriate, and select Summary Statistics

Find the 90% confidence interval for the mean of these values we generate in column A: Choose: Data > Data Analysis Plus** > Z-Estimate: Mean > OK

Enter: Input Range: A1:A40

Standard Deviation (SIGMA): 2.87 > OK

Alpha: .10 > OK

So the 90% confidence interval for the mean is image3.jpg to image4.jpg . ** If “Data Analysis Plus” does not show on the File menu:

Save and Close your excel file

Open: http://www.kellerstatistics.com/KellerStatistics/DataAnalysisPlus Click on: “Download DAPv9” bottom (Mac or Windows)

Save the file > Extract it > open it > double click on Excel file:“Stats_2007-2013_v9b” > Click on “Enable Macros” > Find “Data Analysis Plus” in “Add-Ins” at the menu toolbar of present Excel file > Reopen your previous excel file by dragging inside of present Excel file.

HYPOTHESIS TESTING

A standard final examination in an elementary statistics course is designed to produce a mean score of 75 and a standard deviation of 12. The hypothesis you will try to verify is: "This particular statistics class is above average." At the .05 level of significance, test the claim that the following sample scores reflect an above-average class (assuming sigma = 12):

79 79 78 74 82 89 74 75 78 73 74 84 82 66 84 82 82 71 72 83

Test the hypothesis, "The mean test grade for this class is greater than 75." Choose: Add-Ins > Data Analysis Plus > Z-Test: Mean > OK

Enter: Input Range: A1:A20 or select cells > OK

Hypothesized mean: 75

Standard Deviation (SIGMA): 12 > OK

Alpha: .05 > OK

Questions:

1. What are the formal null and alternative hypotheses?

2. What is the value of the test statistic, and what is your decision? Is the mean of this class above “average”?

UNKNOWN SIGMA

THE CONFIDENCE INTERVAL

To generate a confidence interval using the t-statistic we use Inference about a Mean command, specifying the level of confidence and the column of data for which the estimation is being made.

image5.png

Consider the data presented in exercise 9.31[EX09-031] of your text. Open the data file. Before we complete a 95% confidence interval estimate for the mean length of lunch breaks

at Giant Mart, we check the normal probability plot and boxplot to verify the normality assumption.

Excel uses a test for normality (Chi-Squared Test of Normality), not the probability plot. Choose: Add-Ins > Data Analysis Plus > Chi-Squared Test of Normality > OK

Enter: Input Range: select cells

Select: Labels (if column heading was used) > OK

** IF P-value greater the .05, given distribution is approximately normal.

To complete a 95% confidence interval estimate for the mean length of lunch breaks at Giant Mart complete the following steps:

Choose: Add-Ins > Data Analysis Plus > t-Estimate: Mean > OK

Enter: Input Range: A1:A22

Enter: Alpha: .05 > OK

With 95% confidence we estimate the mean length of lunch breaks at Giant Mart to be between image6.jpg and image7.jpg minutes.

THE T TEST

image8.png

Using text exercise 9.29 [EX02-177] as the basis of our discussion, open the data file. Suppose we have been asked to determine whether this accelerator has decreased the drying time by significantly more than 4% at the 0.01 level.

To perform the test, use the following commands:

Choose: Add-Ins > Data Analysis Plus > t-Test Mean > OK

Enter: Input Range: A2:A9 > OK

Hypothesized mean: 4 Alpha: 0.01 > OK

Question:

3. What are the formal null and alternative hypotheses?

4. Is there sufficient evidence to show that this accelerator has decreased the drying time significantly more than 4% at the .01 level?

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Write My Coursework
Math Guru
Top Class Results
Assignment Helper
Accounting & Finance Mentor
Helping Hand
Writer Writer Name Offer Chat
Write My Coursework

ONLINE

Write My Coursework

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$19 Chat With Writer
Math Guru

ONLINE

Math Guru

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$49 Chat With Writer
Top Class Results

ONLINE

Top Class Results

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$45 Chat With Writer
Assignment Helper

ONLINE

Assignment Helper

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$18 Chat With Writer
Accounting & Finance Mentor

ONLINE

Accounting & Finance Mentor

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$27 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$45 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

What does oedipus promise to do - Colombo frozen yogurt - Role development in professional nursing practice 5th edition pdf - Lab 1 introduction to science - Correlation receiver in digital communication - Dental pro 7 reviews - Advantages of online shopping - Halo effect pmp peter principle - Robot safety and robot safeguarding - Instructional models and strategies - Backslap sunscreen applicator - Apple's ecosystem - Kavo prophyflex 4 instructions - Econ 102 psu exam 1 - Essay - American History SINCE WAR - Health Assessment Topic Reflection 2 - Issuing a note payable is an asset source transaction - Are you for or against globalization - Everett ruess a vagabond for beauty pdf - PowerPoint presentation on depression / scholarly resources from 2015/ no plagiarism - Elite athlete program unimelb - English - Marketing plan for refrigerators - Project proposal - Gain margin and phase margin from nyquist plot - Taming of the shrew act 3 quizlet - Anz internet merchant facility - Jewish poem they came for me - Discussion - Political arithmetic - The william hogarth school - Nsw hsc high achievers 2014 - Rickey smiley paternity test tuesday results - Litany carol ann duffy - Chocolate inc uses a perpetual inventory - Discussion: Mapping Business Challenges to Types of Control - Managing operations across the supply chain 4th edition pdf - Flaws metaphorically 7 little words - Original greenstar display manual - No real number is a pure imaginary number - The most important person in my life essay father - Computer organization and architecture assignment questions - Sales tax office chennai address - Psy 104 week 3 assignment - Malala yousafzai address to the united nations commonlit answer key - Southwest airlines pestel analysis - How to start html using notepad - John tyler testing center - Alexander graham bell parents names - Orthographic or multiview drawings - Critical review journal example - 2.3. Discussion: Borland Case Casting Light and Shadows - C6h8o6 i2 - Discussion question: Leadership Strategy - Facebook whatsapp acquisition case study - Conveyor belt project part 3b answers - Footprinting tools in ethical hacking - Concept Analysis Paper on a nursing topic in this case non compliant diabetic - Duplex receptacle outlet symbol - Two metal cubes a and b of same size - Gatorade vs powerade sales - They say i say table of contents - Ucd medicine entry requirements - Push pull profile strategies marketing communications - Marketing - Cmc vellore appointment for international patients - Snap on mg1250 review - External contingencies sports marketing - The afn equation and the financial statement forecasting - What are the advantages and disadvantages of probation and parole - How do metals and nonmetals combine - The bear by anton chekhov questions - Carina bus depot lost property - Gas inlet bunsen burner - Does jupiter rotate clockwise or counterclockwise - 【HumsafaR--World Famous】+91-9924492424 Love Problem Solution Specialist Baba Ji - Knight frank finance esher - The fluid mosaic model presents the modern view of - Principles of Microeconomics - Financial viability risk assessment requirements - Where do squids live in the ocean - How to predict double replacement reactions - Reinforcers and punishers in psychology - Discussion post - East pastures kennels skelton - Australian curriculum media arts - Pediatric fluid maintenance practice problems - Who does othello allow to bring desdemona to cyprus - How to write a formal analysis - The purpose of picketing is to ___ a labor dispute - Justice: Varying Perspectives - God's bits of wood themes - Density of asphalt base course in kg m3 - Role and Scope DQ5 - On the damned human race - Dr sajida shahnawaz clinic in lahore address - Ansi aiha asse z10 2012 - 10 things i hate about you taming of the shrew - BMGT 495 - Project 4: Strategy Selection, Implementation and Evaluation (Week 8) - Focal Company Cargill PLC