Please show the work on Excel. The Old Town Pasadena parkingreported the following information for a sample of 250 customerson the number of hours cars are parked and the amount they are chargedAmount ChargedNumber of Hours12345678Frequency2038534540135362501. Convert the information on the number of hours parkedto a probability distribution.$3.004. Find the variance and standard deviation of the numberof hours.695. Find the variance and standard deviation of the amount charged2 4 16 18 20122. Find the mean of the number of hours parked.How would you answer the question: How long is a typical customer parked?3. Find the mean of the amount charged.14

Answered: Number of Hours 1 2 3 4 5 6 7 8…

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

Please show the work on Excel.

The Old Town Pasadena parking
reported the following information for a sample of 250 customers
on the number of hours cars are parked and the amount they are charged
Amount Charged
Number of Hours
1
2
3
4
5
6
7
8
Frequency
20
38
53
45
40
13
5
36
250
1. Convert the information on the number of hours parked
to a probability distribution.
$3.00
4. Find the variance and standard deviation of the number
of hours.
6
9
5. Find the variance and standard deviation of the amount charged
2 4 16 18 20
12
2. Find the mean of the number of hours parked.
How would you answer the question: How long is a typical customer parked?
3. Find the mean of the amount charged.
14

Expert Solution

Step 1

Hi! Thank you for the question. As per the honor code, we are allowed to answer three sub-parts at a time so we are answering the first three as you have not mentioned which of these you are looking for. Please re-submit the question separately for the remaining sub-parts.

Given data: