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 plus excel 2019

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

LAB SESSION 3

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:

Engineering Help
Essay & Assignment Help
Custom Coursework Service
Financial Analyst
Math Exam Success
Coursework Assignment Help
Writer Writer Name Offer Chat
Engineering Help

ONLINE

Engineering Help

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$28 Chat With Writer
Essay & Assignment Help

ONLINE

Essay & Assignment Help

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$44 Chat With Writer
Custom Coursework Service

ONLINE

Custom Coursework Service

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.

$41 Chat With Writer
Financial Analyst

ONLINE

Financial Analyst

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$50 Chat With Writer
Math Exam Success

ONLINE

Math Exam Success

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.

$39 Chat With Writer
Coursework Assignment Help

ONLINE

Coursework Assignment Help

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$21 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

Christian dior financial statements - Biotic factors in the everglades - Flipkart ebay merger case study - Homogeneous aqueous systems 15.2 answers - Conflict theory of aging - Leader competencies essay - Ccis d2l - Visual basic programming exercises - Readiness for enhanced coping care plan - Which of the following situations would be considered cyclical unemployment? - Strategic managment - Write an article - Blue collar brilliance summary and response - Computing - Bessie dunlop witch of dalry - Uts referencing guide apa - Mauchly's test of sphericity spss no value - Bsi teradata case of the misconnecting passengers - Apply porter's value chain model to costco - Week 7 Assignment: Case Study - Web dubois vs booker t washington poem - Don sabo pigskin patriarchy and pain - Physical Security - Voltage divider circuit using transistor - 2/1 - Leadership Development Plan - Food safety program records - Ten frame blackline master - Barbano v madison county case brief - Merger and acquisition notes for mba - This is what it means to say phoenix arizona theme - The rime of the ancient mariner questions and answers pdf - Paper planes urban dictionary - Fake driving licence uk template - How to make a gpa calculator in visual basic - A level business coursework - Shoe fitting fluoroscope cancer - Atonement london 1999 summary - Delrin 500p material properties - Journalize the april transactions using a periodic inventory system - Knox park primary school - Anz eftpos network attach in progress - Mba 503 milestone 2 - Biology critique - Hazardous industries and chemicals branch - Annotated bibliography for 5 scholarly sources. - Nursing care plan - WK4 Assignment-Quantitative Research Critique - Digital electronics lab manual - Counting on and counting back - Https writingcenter unc edu tips and tools literature reviews - Ananda everingham speaking english - Assume the following relationships for the brauer corp - Boyle's law data table - Bath water temperature celsius - Alice in wonderland cast list - Mondelez international global strategy - What is a sustainable mis infrastructure - Correlation - Detective hugo gattaca quotes - Information System Analyst - Quotes for scout in to kill a mockingbird - What is regenerated in fermentation - Comin thro the rye analysis - What are the abcd's of nutritional assessment - Calorimetry and hess's law - History of Art through the Middle Ages (Project) - Customer relationship management crm at samsung company - 2017 naplan writing prompt - Romantic vs victorian poetry - Mental Health in African Americans in College - Am i too fat for disneyland paris rides - Two dimensional steady state heat conduction examples - Transaction model of communication - Eylf planning cycle acecqa - Response to Classmates Discussions - Negotiation strengths and weaknesses - High five reading strategy - Flight school manager rmit - Gender studies - Business ethics case studies and selected readings free pdf - William ransom primary school - When the price of a good falls, there will be - When was glass windows invented - Manrose mf100t installation manual - Riga to copenhagen ferry - Leicestershire midweek floodlit youth league - 2973 kj to calories - Anglo saxon belt buckle - 1o mins quiz for econ - Ocr additional science grade boundaries 2015 - Project - Psychology - How to reset thermo king codes - University of birmingham physician associate - Philosophy - Community assessment project nursing - According to president mandela what is the essence of leadership - Physics exam - Flow measurement lab report discussion