Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Math 1342 excel spresdsheet

Can anyone help with excel and statistic?

1.

Top of Form

Again, you will use the student survey from the Excel spreadsheet given at the beginning of the course: 
MATH 1342 Database.xlsx

Find two free cells in the spreadsheet to enter the appropriate formulas to find the mean and standard deviation of the DRIVE variable by using
=AVERAGE(A2:A36) and =
STDEV(A2:A36).

(Round your answers to 5 decimal places)

Fill in the blank:

The
mean of the DRIVE variable is
Blank 1.

The
standard deviation of the DRIVE variable is
Blank 2.

· Blank 1

· Blank 2

Bottom of Form

2.

Top of Form

Question 2

Question 2

2 Points

Question 2

Assuming that this variable is normally distributed, what proportion of the data would you predict to be less than 40 minutes? This would be based on the calculated probability.

To approximate this probability with Excel, find a free cell on the spreadsheet and use the formula
=NORM.DIST(40,mean,stdev,TRUE). For the “mean” and “stdev” in the formula, you

don’t
want to type those words, you want to actually enter the cell numbers in which you just found the average and standard deviation of your DRIVE variable.

(Keep your answer in decimal form and round your answer to 3 decimal places)

Fill in the Blank: The proportion of values that I expect to be less than 40 minutes is _____________.

Blank 1

· Blank 1

Bottom of Form

3.

Top of Form

Question 3

Question 3

2 Points

Question 3

Now, determine the

actual
proportion of data points in the dataset that fall within this range (less than 40 minutes). To find the actual proportion, sort the DRIVE variable, and count how many of the data points are less than 40. Then, divide that number by the total of 35 data points.

(Keep your answer in decimal form and round your answer to 3 decimal places)

Fill in the Blank: The actual proportion of values less than 40 minutes is ___________.

Blank 1

· Blank 1

Bottom of Form

4.

Top of Form

Question 4

Question 4

2 Points

Question 4

How does your predicted probability from question 2 compare to the actual probability calculated in question 3? In other words, if these values are different, why do you think they’re different, etc?

Option A

The probability calculations are different. In part 2, we calculated the probability based on the assumption that the distribution of the “drive” variable is normally distributed. If the distribution is not bell-shaped, then the probability estimation (in part 2) would not be accurate.

Option B

The probability calculations are the same.

Option C

The probability calculations are different. This must mean that something is wrong with our technology.

Bottom of Form

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

ma

Handout #4 Math 101 Name: _____________________________ Basic Probability & Odds Two dice are rolled. Use the table from our notes to identify the sample space. Then calculate the probability of each event. 1. What is the probability that we roll a sum less than 8? 2. What is the probability

MAT DB V

See attached Unit V Discussion Board Watch  Video 3: The Power of “Yet,”  and evaluate your course progress. Are you meeting your goals for the course? What goals do you have for the remainder of the class? What strategy can you implement to help you achieve those goals? Next, respond

MAT IV JL

See Attached Watch the  video  The Power of Making Mistakes . Describe a situation where you made a mistake in this course. How can you learn from your mistake in order to better understand the course material? What did this mistake teach you? If this was another person describing their

home work

Competency Evaluate hypothesis tests for population parameters from two populations. Project Deliverable tie to Competency  In your fifth assignment, you will continue applying hypothesis testing methods to real-world situations. This assignment will require you to expand your understanding of situations that involve comparing two populations, which is a critical skill

home work

Competency Evaluate hypothesis tests for population parameters from one population. Project Deliverable tie to Competency  In the fourth assignment, you will need to make data-driven decisions by evaluating claims about a single population. You will be tasked with completing several hypothesis tests, which follow a structured process: stating hypotheses, selecting

it is a MATHEMATICS QUESTION

  Three resistors of 2 Ω, 3 Ω and 6 Ω are connected in parallel. This combination is connected in series with a 4 Ω resistor. The whole circuit is connected to a 12 V battery. Find: Total resistance of the circuit   Total current from the battery   Current

home work

Competency Develop a confidence interval for a population parameter. Project Deliverable tie to Competency  In the third assignment, you will construct and interpret confidence intervals, which is a fundamental concept in inferential statistics. By estimating population parameters such as the mean and proportion using sample data, you will gain a

Math

Which inequality is equivalent to –m ≥ 15? CLEAR CHECK m ≥ 15 m ≥ -15 m ≤ -15 m ≤ 15

Home work

Competency Apply the normal distribution, standard normal distribution, and central limit theorem. Project Deliverable tie to Competency  In module 02, you will summarize graphical and numerical methods to represent quantitative data. This includes utilizing the central limit theorem to calculate probabilities for real-world problems. It will also require you to

math 210 wk 9 i need healp

MAT210 – Week 9 Assignment Template Week 9 Assignment Template Making Data Driven Decisions Name:  Case Study:    1. Construct a box-and-whisker plot in Excel for the data set you used in your ALEKS assignment for this week. Paste that below. 1. Evaluate the results of the hypothesis test and

VII Math

See Attached Unit VII Math Journal Throughout this course, you have had access to unit study guides, reference sheets, note-taking guides, instructional videos, and learning aides. Reflect on how you used these resources to help you complete each assignment thus far, and describe how you can use these resources to

mat 210 wk 9

How to construct a box and whisker plot excel? MAT210 – Week 9 Assignment Template Week 9 Assignment Template Making Data Driven Decisions Name:  Case Study:    1. Construct a box-and-whisker plot in Excel for the data set you used in your ALEKS assignment for this week. Paste that below.

mat 210 wk 3

Which scatter plot would be best to use for a study? MAT210 – Week 3 Assignment Template Week 3 Assignment – The Foundation of Data-Driven Decisions Name: [Add your name] Professor Name: [Add your professor’s name] Date: [Add the Date Submitted] Scenario: You would like to determine whether eating before

Unit V DB Math

See attached DB V Math This unit covers different counting methods: the fundamental counting principle, combinations, and permutations. Complete each of the following:   1. Choose one of these topics and explain it to your classmates in your own words. 2. Create an example using the counting method you chose.

MINi PROJECT

2021Fall_IE342_MiniProject2 5 (Instructor: Azadeh Haghighi) Mini Project 2 Directions: In this project, you are going to graphically present, study, analyze and evaluate the distributions of a dataset. Upload your whole package (including any codes, plots, and the report) to the blackboard by the due date. The Data: Collect the size

Compressed Sensing: Das mathematische Wunder, aus Wenigem Alles zu machen

  Das Limit von Nyquist brechen Lange Zeit galt in der Signalverarbeitung ein ehernes Gesetz: das Nyquist-Shannon-Abtasttheorem. Es besagt vereinfacht: Wenn du ein Signal (z.B. Musik oder ein Bild) perfekt aufnehmen willst, musst du es sehr oft messen (abtasten). Wenn du zu wenige Daten hast, verlierst du Information. Doch seit

Dimensional Analysis

Dimensional Analysis is a multi-step conversion process to convert one unit into another. You will use dimensional analysis to create a presentation this week.   Scenario:  A mother has been given a prescription for her child. She fills the prescription at her local pharmacy. When she gets home, she reads