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

Excel add ins data analysis plus

19/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:

Professor Smith
Math Specialist
Quick N Quality
Math Exam Success
Custom Coursework Service
Isabella K.
Writer Writer Name Offer Chat
Professor Smith

ONLINE

Professor Smith

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$30 Chat With Writer
Math Specialist

ONLINE

Math Specialist

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

$24 Chat With Writer
Quick N Quality

ONLINE

Quick N Quality

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.

$27 Chat With Writer
Math Exam Success

ONLINE

Math Exam Success

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$21 Chat With Writer
Custom Coursework Service

ONLINE

Custom Coursework Service

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.

$46 Chat With Writer
Isabella K.

ONLINE

Isabella K.

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

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

1.5x iqr rule calculator - All summer in a day - Economics is best described as the - Jollibee party hacks 50 persons - Quiz 3 reaching a conclusion about your career ministry - Balancing redox reactions using half reaction method - (DQ) Biz News - Consumer behavior - Excel chapter 4 capstone exercise - Cost driver for material handling - Triumph owners club wirral - History - Help 1 - Coastal tyres direct urangan - Health talk on diabetes mellitus ppt - Due Tonight by 10 pm - ESSAY - As 1627.4 class 2.5 - Mclaren vale associates legacy shiraz 2016 - Worcester pump overrun kit - Centripetal rash examples - Roots of polynomials exam questions - The comparative balance sheet of yellow dog enterprises in - Advantages of electric heating - Lysaght longline 305 price - What did ned kelly achieve - Creative classroom connections worksheets - What does undefined term mean in geometry - How does diversification and acquisition create value for a company - Difference between eis and dss - Cnss security model in information security - Nani surun desu ka - Glandore private kindergarten and child care centre - Human resource management mcgraw hill test bank - Rob is responsible for estimating a work package - Solve ax2 bx c 0 by completing the square - 2.4 4 test ts sins and crimes answers - Palo alto vpn logs - Which of the following best describes the psychological concept of self-efficacy? - The future of nursing institute of medicine - Developing python app - Ducksters world war 1 - Discussion: What Do I Value? - Reading Responses(Less Than 1 Page) - Earth rite multipoint ii - Im my own grandpa pedigree - Http www magickeys com books patrick index html - Excel sam capstone project 1 campus fitness center - BUSINESS ENVIRONMENT, ETHICS & STRATEGY(case study) - Little red hen nursery maidenhead - Business valuation report format in word - Convert morse code to text c++ - Recessed data wall box - Https honda garmin com honda site generalinstructions - The pedestrian by ray bradbury questions - A glass of milk story author - Simon armitage mother any distance - Grief quotes in the tempest - Bin day moreton bay - Use the following data to calculate the current ratio - How to make a hovercraft that you can ride on - Property valuation report example - Educational seminar invitation template - 2-4 pages - Office 365 sign in ucl - Essay 8 to 10 GUARANTEE AT LEAST B - Lyrics to abc song by jackson 5 - Integrative approaches to psychology and christianity entwistle - Is college worth the cost essay - Be cool to the pizza dude summary - Intermittent pilot ignition wiring diagram - Spatial organization presentation psy 345 - Drunk driving persuasive speech outline - Hrm tree trimming - Living world stage 1 - Discussion 1 and 2 ,250 words each one by 10/20/2020 at 6 :00 pm,please add references - Bigfoot bbq restaurant & catering flagstaff az - Reflective memo - Problem 9 4 preparing an income statement - How to change the theme to retrospect in excel - Ethics of Journalism - Qconnect journey planner qld - New novel complex decisions having no proven answers are - Business partnership proposal email - Le chatelier's principle lab answers - Learning experience plan childcare - Sap material type definition - The privacy act of 1974 applies directly to ____ employees. - Jasper jones jeffrey lu cricket - Centerlink deduction for immediate payment - Given positions find velocity and acceleration mastering physics - Capital project fund journal entries examples - Vaf1b visa application form - Coefficient of friction anodized aluminum - Nursing information management and technology discussion W2 - What is the empirical formula of hydrogen peroxide - Melbourne gpo private box centre - 1-1 Discussion: Jurisdiction and Venue in Cyberspace - Due today by 10pm - How to cite mythology - WK-2