Question: Compete all work in a single Excel file. Use Excel functions whenever possible to answer the questions below. Show all steps and values. Report any

Compete all work in a single Excel file.

Use Excel functions whenever possible to answer the questions below. Show all steps and values. Report any numbers in APA format

Label your work clearly.

Upload the Excel file to OWL.

A scale measuring personal negativity has a population mean of 200 and standard deviation of 12. You and 5 of other Psychology students complete the test. You and the other students obtain scores of 189, 175, 189, 211, 201 and 203.

A) Use data analysis tools to determine the range (2 marks)

B) Given the population values, what is the probability of a sample mean (n = 6) less than the mean obtained by the group of you and the 5 other students? Report the test statistic and probability to 2 decimal places. (6 marks)

please provide screenshot of excel doc

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

if anyone can help me out it would be greatly appreciated. This assignment is basically hieroglyphs to me and the rest of my class. Cools Table Window Help G D Assignment 2--HPR calculations with...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

Any help would be greatly appreciated, this assignment is basically hieroglyphs to me and the rest of my class. Due 6pm (submit to ReggieNet) Thursday Feb 27, 2020 25 points Note: Set Excel to show 4...

Any help would be greatly appreciated. Due 6pm (submit to ReggieNet) Thursday Feb 27, 2020 25 points Note: Set Excel to show 4 decimal places in your answers, whether decimal format (0.0123) or...

PROJECT OVERVIEW First, save this file as Process Costing_namelD#_name ID# (fill in name and ID# for BOTH you and your partner using your LAST NAMES and CLASS ID NUMBERS. Example: "Process...

1) How much cost, in total, needs to get transferred to the Forming Department? Complete the journal entry with the appropriate amount. 2) The controller wants to know the cost of making one unit of...

if someone could please show me how to complete this on excel that would be appreciated Ground Rules This project will require you to create an Excel spreadsheet and upload it to Canvas. You must do...

HEW! mammal-(mm v| 11 -iK AJ} E . :2 saw? him - I . '31; 2 gm\" 11?. '13.\": ____ _ ____ _ __ '95 :Hr E1\";- Z ' 'lh( ' ' All Ann m5 v\" | B . I . E :v\\ , tug. 2; 4' Av' H gav lg. .95 luuuljdj am...

Need Urgent Help with Question 3 and Question 9 of the attached document - Question 3 needs only ~400 words (also attaching an article which might be needed to answer question-3) My word count for...

Hi Cedrick, Can you work on this? Please check and let me know. Maraming Salamat. FINANCIAL FORECASTING Apply Principle 1 and Principle 2 to make Excel do as much of the work as possible. Worksheet...

Which of the following situations would be considered ethical? A. The cashier at Wal-Mart gives you $5 more than you were supposed to receive and you don't do anything about it. B. You accidentally...

Graph the function by hand, not by plotting points, but by starting with the graph of one of the standard functions given in Section 1.2, and then applying the appropriate transformations. a. y = 1/x...

E6.3 A system has the characteristic equation s4 + 10s3 + 32s2 + 37s + 20 = 0. Using the Routh-Hurwitz criterion, determine if the system is stable.

Focusing on the causes of risk that we have exposed in item 8 concerning exports, choose two of them and pose a problem and a possible solution to this problem.