Compute the relative and cumulative relative frequencies

Assignment Help Basic Statistics
Reference no: EM132843741

1. Use the Histogram tool to develop a frequency distribution and histogram for the number of months as a customer of the bank in the Excel file Credit Risk Data. Use your judgment for determining the number of bins to use. Compute the relative and cumulative relative frequencies and use a line chart to construct an ogive.

2. Construct frequency distributions and histograms using the Excel Histogram tool for the Gross Sales and Gross Profit data in the Excel file Sales Data. First let Excel automatically determine the number of bins marital status associated with these loans and bin ranges. Then determine a more appropriate set of bins and rerun the Histogram tool.

3. The Excel sheet Sampling contains the responses on a sale of 1 to 5 from consumers regarding a product. Construct a cluttered pivot table. And show the sampling data in the histogram.

4. Find the 20th and 80th percentiles of home prices in the Excel file Home Market Value

5. Find the 10th and 90th percentiles and 1st, 2nd, and 3rd quartiles for the combined amounts of checking and savings accounts in the Excel file Credit Risk Data.

Reference no: EM132843741

Questions Cloud

What is the approximate value of the expected inflation rate : If the nominal interest rate is 12% and the real interest rate is 7%, what is the approximate value of the expected inflation rate?
What are the possible values of the variable : 1) A statistics quiz consists of 5 multiple choice problems with 4 choices for each problem. What are the possible values of the variable, number of correct ans
What is a liquidity premium : What is a "liquidity premium"? Extra return due to the lack of liquidity associated with long term investments. / Extra return due to the lack of liquidity.
State null and alternative hypothesis for single factor : The table below shows data on research to examine the perception of business ethics among 3 groups of employees (higher score indicates higher ethical values).
Compute the relative and cumulative relative frequencies : Use your judgment for determining the number of bins to use. Compute the relative and cumulative relative frequencies and use a line chart to construct an ogive
Which is not an prediction of the pure expectations theory : Which is NOT an prediction of the pure expectations theory? Long term interest rates will be the geometric average of expected future short term rates.
What suggestions would you offer to better facilitate plans : In this unit's Discussion Board, you will relate developmental theories to the specific issues faced by children in their middle childhood.
What is my greatest asset as a leader : Ask someone you trust and who can be objective, "What is my greatest asset as a leader?" In your journal, record the response
Estimate of the relative frequency of the series : Find the probability distribution of T. Is (B-1)/ (T-1), B>1 an unbiased estimate of the relative frequency of the series under consideration.

Reviews

Write a Review

Basic Statistics Questions & Answers

  Calculating probabilities of normal-standard normal

Identify the Excel functions used for calculating probabilities of normal and standard normal distributions

  Knowledge about confidence interval for mean

Merrill Lynch Securities and Health Care Retirement, Inc., are two large employers in downtown Toledo, Ohio. They are considering jointly offering child care for their employees.

  Normal disrtibution of fish lengths

Use normal disrtibution of fish lengths for which the mean is 8 inches and the standard deviation is 5 inches. Assume the variable x is normally distributed.

  Statistics for Business Decisions Tutorial Questions

What is the conditional probability a respondent uses social media and other websites to voice opinions about television programs

  Fairly dealt hands from a fair deck and why

Joe dealt 20 cards from a standard 52-card deck, and the number of red cards exceeded the number of black cards by 8. He reshuffled the cards and dealt 30 cards. This time, the number of red cards exceeded the number of black cards by 10. Dete..

  Describe the fallacy for the conventional bomb

An atomic bomb causes more damage than a conventional bomb. Therefore, during World War II more damage was caused by atomic bombs than by conventional bombs.

  Seizure-alerting and-response behaviors

"Seizure-Alerting and -Response Behaviors in Dogs Living with Epileptic Children" reported in the journal Neurology in June 2004 that 9 out of 60 dogs in famili

  Public health and nutrition

The National Advisory Committee on Immunization in Canada provides the public with specific health recommendations and summary reports

  Show that another expression for the chi-squared statistic

b. When the null hypothesis is    how does the formula of part (a) simplify? Use the simplified expression to calculate x2 for the pigeon/direction data in Exercise 4

  Demographics of study sample and correlational analysis

The following are a series of analyses that describe the demographics of the study sample and a correlational analysis intending to answer the study question

  What confounding variables can be controlled in the analyses

There is considerable controversy among scientists about the potential carcinogenic effects of magnetic fields. Several epidemiology studies have suggested.

  Random sample-test claim

A random sample of 160 car crashes are selected and categorized by age. The are listed below. The age distribution of for the given categories is 18% for under 26, 39% for 26-45, 31% for 46-65, and 12% for over 65.

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