QuickHelper

(10)

$20/per page/

About QuickHelper

Levels Tought:
Elementary,High School,College,University,PHD

Expertise:
Accounting,Applied Sciences See all
Accounting,Applied Sciences,Business & Finance,Chemistry,Engineering,Health & Medical Hide all
Teaching Since: May 2017
Last Sign in: 356 Weeks Ago
Questions Answered: 20103
Tutorials Posted: 20155

Education

  • MBA, PHD
    Phoniex
    Jul-2007 - Jun-2012

Experience

  • Corportae Manager
    ChevronTexaco Corporation
    Feb-2009 - Nov-2016

Category > Accounting Posted 31 Aug 2017 My Price 11.00

Business statistics, statistics homework help

Question description

 

This is an assignment in my business statistics class (FINA 220)

This assignment consists of solving 4 problems from the textbook (Statistical Techniques in Business and Economics, 16 th Edition, McGraw-Hill), two from chapter 2 and two from chapter 3. Excel data files are provided below for each of the problem. When you solve the 4 problems, please copy the data into 4 tabs of one Worksheet before you start. Do not keep it in 4 files.

Here are the problems:

2.30) The weekly amounts spent on groceries for a sample of 45 households is provided in the attached file.

a) How many classes would you recommend for grouping the data?

b) What class interval would you suggest?

c) What would you recommend as the lower limit of the first class?

d) Organize the data into a frequency distribution.

e) Plot the distribution using a bar chart in Excel.

2.43) Merill Lynch recently completed a study regarding the size of online investment portfolios (stocks, bonds, mutual funds, and certificates of deposit) for a sample of clients in the 40 up to 50 years old age group. The value of all investments in thousands of dollars for the 70 participants in the study is provided in the attached file.

a) Organize the data into frequency distribution. How many classes would you suggest ? What value would you suggest for a class interval?

b) Draw a histogram. Inerpret your results.

c) What is the mean, the variance, and the standard deviation of the data?

3.65 A sample of households that subscribe to United Bell Company for landline phone service revealed the following number of calls received per household last week (see attached data file for the numbers). Determine the mean and the median number of calls received.

3.77 The enrollments of the 13 public universities in Ohio is given in the attached data file.

a) Is this a sample or a population?

b) What is the mean enrollment?

c) What is the median enrollment?

d) What is the range of enrollments?

e) Compute the standard deviation.

Attachments:

Answers

QuickHelper
(10)
Status NEW Posted 31 Aug 2017 06:08 PM My Price 11.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k Y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l

Not Rated(0)
Relevent Questions