The one in yellow is tab 1. Suppose the number of car crashes in a state on any given day is 43 with a standarddeviation of 3.4. Assume the statistics are normally distributed.Use the Excel formulas from tab #1 to answer the following and show your work inthe cells on the right.a. Find the probability that more than 44 crashes occur today.b. Find the probability that less than 42 crashes occur today.c. Find the probability that between 42 and 44 crashes occur today. Find the p-value of a Normal Distribution using Mean u = 8 andPopulation Standard Deviationo= 2In cell B3 type: -NORM.DIST(10,8,2,1)Less thanThis includes the value x, then the mean, then standard deviation and 1 for the cumulative result.P(X<10)Greater than P(X>10).In cell B4 type: =1-NORM.DIST(10,8,2,1)P(S

Answered: Suppose the number of car crashes in a…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

The one in yellow is tab 1.

Suppose the number of car crashes in a state on any given day is 43 with a standard
deviation of 3.4. Assume the statistics are normally distributed.
Use the Excel formulas from tab #1 to answer the following and show your work in
the cells on the right.
a. Find the probability that more than 44 crashes occur today.
b. Find the probability that less than 42 crashes occur today.
c. Find the probability that between 42 and 44 crashes occur today.

Find the p-value of a Normal Distribution using Mean u = 8 and
Population Standard Deviationo= 2
In cell B3 type: -NORM.DIST(10,8,2,1)
Less than
This includes the value x, then the mean, then standard deviation and 1 for the cumulative result.
P(X<10)
Greater than P(X>10).
In cell B4 type: =1-NORM.DIST(10,8,2,1)
P(S<X<9)%3DP(IX<9)-P(X<5)
Between
In cell B5 type: =NORM.DIST(9,8,2,1)-NORM.DIST(5,8,2,1)
(Notice the larger value is written first)
Complete cels 67 to B9 in the same manner

Expert Solution

Step 1

Normal distribution is a continuous distribution which has many real life applications. Normal curve is a bell shaped curve and it is symmetric about the mean.

A standard normal distribution is a normal distribution with mean 0 and standard deviation 1. For a normal distribution, mean, median and mode is equal.

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Translations$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions