Excel or megastat to sort and standardize the data

Assignment Help Basic Statistics
Reference no: EM132581606

Below are monthly rents paid by 30 students who live off campus.

630 630 630 830 600 490

590 930 640 520 620 580

460 640 550 560 750 820

500 520 660 590 610 400

630 700 720 740 620 650

a). Using Excel, find the mean, median, mode, and standard deviation. (Round your answers to 2 decimal places)

Descriptive Statistics Data

Mean _______

Median _______

Mode _______

Standard Deviation _______

b). Use Excel or MegaStat to sort and standardize the data. What is the z-score for the following rent value? (Round your answer to 2 decimal places)

Rent Value z-Score

740 ________

Reference no: EM132581606

Questions Cloud

Standard normal random variable : Given that z is a standard normal random variable, find z for each situation. (Round your answers to two decimal places.)
What is the probability of selecting someone diabetes : What is the probability of selecting someone who does not have diabetes, given that they are on a feeding tube?
What is the probability that a random sample of an equals : What is the probability that a random sample of an equals 40 oil changes results in a sample meantime less than 10 minutes
What is the 1st quartile of the data : The following table represents the number of clicks an ad receives an hour for 36 hours, sorted and arranged in rows of 5. What is the 1st quartile of the data?
Excel or megastat to sort and standardize the data : a). Using Excel, find the mean, median, mode, and standard deviation. (Round your answers to 2 decimal places)
What is the probability that the length of stay in the icu : Intensive care units (ICUs) generally treat the sickest patients in a hospital. ICUs are often the most expensive department
What is the probability there are 1900 or fewer : What is the probability there are 1,900 or fewer downloads of Amazon Alexa in a day? (Round your answer to four decimal places.)
Create one thread on discussion board : To Do: Create one thread on Discussion Board about 3 examples of the following:
Classify transatlantic gateway airports : A business travel magazine wants to classify transatlantic gateway airports according to the mean rating for the population of business travelers

Reviews

Write a Review

Basic Statistics Questions & Answers

  Inferences about two proportions

A simple random sample of front-seat occupants involved in car crashes is obtained. Among 2823 occupants not wearing seat belts, 31 were killed. Among 7765 occupants wearing seat belts, 16 were killed.

  Use graphical method to describe data summarized in table

Of the firms that provided blogs/forums as a marketing tool, the accompanying table gives a breakdown on the entity responsible for creating the blogs/forums. Use a graphical method to describe the data summarized in the table. Interpret the graph..

  Complete the simulation applying time series

Complete the simulation Applying Time Series Methodologies located on . During the third cycle of the simulation, you will need to make a decision regarding sales forecasts for Blues Inc.

  Annual productivity improvement in the prior year

Refer to Productivity improvement Problem 16.7. The economist also has information on annual productivity improvement in the prior year and wishes to use this information as a concomitant variable. The data on the prior year's productivity im..

  Why is the required sample size larger

The sample size formula for a confidence interval for the population mean requires an estimate of the population standard deviation.- why is the required sample size larger if the population standard deviation is larger.

  Software for teaching creative writing

An educational software company wants to compare the effectiveness of its computer animation for teaching creative writing with that of a textbook presentation.

  What should the limit be

If a country wants to set the mileage limit at a point such that 80% of the tourists in the program will want to drive fewer kilometers, what should the limit be?

  Define appropriate null and alternative hypotheses

a. First, are these statistics given by United describing the parent population or a sample? b. Define appropriate null and alternative hypotheses.

  Find confidence interval for the success rate at the clinic

Pregnancy. In 1998 a San Diego reproductive clinic reported 49 live births to 207 women under the age of 40 who had previously been unable to conceive.

  Determine how comfortable the shopper was in a store

the study obtained a measure to determine how comfortable the shopper was in a store. Higher scores indicated greater comfort. Suppose the following data were collected. Use a = .05 to test for differences among comfort levels for three types of b..

  A student studying for a vocabulary test knows the meanings

1 a student studying for a vocabulary test knows the meanings of 14 words from a list of 20 words. if the test contains

  Determine whether or not a dataset contains an outlier

Does a stem-and-leaf plot provide sufficient information to determine whether or not a dataset contains an outlier? Explain.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd