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

Pure blonde dan murphys - The great gatsby main idea - The purpose of the sales budget report is to - Ancestor doll school project - What are some examples of discretionary benefits - Name three substances found in perspiration - Complete combustion of propane - Unit 8 assignment - Critical thinking moore and parker pdf - This i believe writing assignment - E compensation tools in the job evaluation process - Harry markham's loyalty dilemma - Managerial KSA - Evo essay - Critique Essay - Jamba juice net worth - Leadership and the one minute manager cliff notes - Business Organizations - Is the world flat or spiky - Define internal and external stakeholders - Structuredquery log temp folder - Sales rep at universal containers create multiple quotes per opportunity - Http www lib usm edu legacy plag plagiarismtutorial php - Bt home monitor vp1000 key fob - 6 sources of influence - General manager report template - Leading edge flying club - Atomic theory timeline for kids - Under the moon movie - 8th letter of the greek alphabet crossword clue - Case study break even analysis - Two different methods of estimating bad debts - Microflix activity immunology infection and initial response - Aci 350.1 10 testing reinforced concrete structures for watertightness - Types of intermediate sanctions - Worksheet 3 solution solute solvent soluble answers - Skinpen by bellus medical for sale - In this assignment, you will evaluate a current organizational structure and recommend structural changes that can help address the concerns the organization identified regarding collaboration, communication, and autonomy. - Node bad option inspect brk - MKT 315 Wk2 DQ1 - Planet fitness swot - Bus 419 discussion - Summarize and answer questions - Central sterilization technician job description - Conflict resolution form template - Https searchsqlserver techtarget com definition database - Sec form def 14a instructions - The importance of carrying out a detailed skin analysis - Cordially invite you and your family - History Reading Assignment - Corporate Finance - Global citizenship and equity assignment - Rm maths learning system - PSYC Life Span Development Psychology - Due today - What is the mood of the poem silver - 5 pillars of sustainable change - G http www adobe com go reader_download - Traditional and contemporary management strategies - Bus 499 discussion question - Aama certification program windows - Leadership Theory Analysis paper - Re expressing data definition - Expression of interest template word - Telecomm Network Security - Rose & frank co v jr crompton & bros ltd - Agassi company uses a job order cost system - Dr bernard cheong clinic - Sew what inc business performance - Disney president who oversaw the pixar acquisition - ORGANIZATIONAL CRISIS - Bogglesworldesl the water cycle answers - Positive and negative rules - Plural nouns spelling rules - Bus 311 week 2 assignment - Www jessopmedicalpractice co uk - Home by gwendolyn brooks analysis worksheet answers - Complete the concept map comparing mitosis and meiosis - Aida principle of advertising - Guru Olivia Only - Psychology literature - Medieval europe word search - Introduction to signals and systems edward w kamen - Casa overseas licence conversion - Chemical companies in jurong island - Accumulated depreciation and depreciation expense are classified, respectively, as - Convex slope contour lines - Big bertha stories by bobbie ann mason - Help due tomorrow by 2:59 am eastern standard - How markets allocate resources - Taxi eschewer for short crossword - Alfred doolittle middle class morality - Toolpro valvoline tool chest 3 drawer 26 inch - Parmesan cheese pick n pay - Read and write more than 300 words. - The most loneliest day of my life grammar - Finding the best buy case study - Which source would you consult to read the text of a televised interview? - Major fish diseases and their control ppt - Developing critical reading skills 9th edition answer key