Create a multiple regression model

Assignment Help Basic Statistics
Reference no: EM131463411

Part 1

ANALYSIS ASSIGNMENT 1

QUESTIONS

1. Determine the range, standard deviation, and variance for the indicated data set.

a. SET A

b. SET B

c. SET C

d. SET D

e. SET E

f. SET F

Set A Ages of people that attended an Alcoholics Anonymous (AA) therapy session: 25,
44, 20, 37, 56, 51, 34, 41, 36, 61, 33, 31, 47, 63, 67

SET B Grades on the second test of ECT 120 class: 77, 80, 87, 67, 88, 77, 12, 93, 78, 44,
71, 86, 40, 100, 76, 83, 66, 62, 89, 79, 81, 52, 30, 71, 76, 100, 74, 65, 82, 100,
56, 35, 51, 59, 29,13, 71

SET C Number of defective resistors per package of 100: 5, 10, 3, 2, 1, 9, 4, 10, 5, 3, 5,
5, 7, 11, 20

SET D States within the USA with National Parks:

STATE

Number of National Parks

Alaska

8

Arizona

3

Arkansas

1

California

8

Colorado

2

Florida

3

Hawaii

2

Idaho

1

Kentucky

1

Maine

1

Michigan

1

Minnesota

1

Montana

2

Nevada

2

New Mexico

1

North Carolina

1

North Dakota

1

Oregon

1

South Dakota

2

Tennessee

1

Texas

2

Utah

5

Virginia

1

Washington

3

Wyoming

2

SET E Normal Monthly Precipitation in MiamiFlorida. Data taken over 30 years from
1961- 1990.

Month

Precipitation

Inches (in.)

January

2.01

February

2.08  

March

2.39

April

2.85

May

6.21

June

9.33

July

5.70

August

7.58

September

7.63

October

5.64

November

2.66

December

1.83

SET F Annually Year Precipitation in selected US Cities. Data taken over 30 years from 1961- 1990.

City

Precipitation

Inches (in.)

New York City

47.25

Dodge City, KS

21.49

Detroit, MI

32.62

Honolulu, HI

22.02

Atlanta, GA

50.77

Hilo, HI

129.19

Tallahassee, FL

65.71

Orlando, FL

48.11

Bakersfield, CA

5.72

Alamosa, CO

7.57

Chicago, IL

35.85

Los Angeles, CA

14.77

Bridgeport, CT

41.66

New Orleans, LA

61.88

Las Vegas, NV

4.13

Binghamton, NY

36.99

Dallas, TX

33.70

Houston

46.07

Seattle

38

2. Jacklyn scored 100, 95, 80, and 92 on her last four calculus tests. What must she score on the last test in order to earn the grade of A? The grading scale of an A is 90 -100.

3. Ms. Alicia Renee Mc Cormick's Report Card

       Course Credit                   Course Letter Grade

                 4                                           B

                 3                                           C

                 3                                           A

                 1                                           A

                 3                                           B

                 3                                           A

What is Alicia's GPA?

4. Below is Tom's grade distribution and recorded scores from his physics class. What is Tom's grade (weighted average)?

Sample Grade Distribution Chart

         HW                    10% [Drop the lowest]

         Midterm             25%

         Final                   30%

         Quiz                   30% [Drop the lowest]

         Lab Reports       15%

 

         HW:                  25        60        90        85        100      100      100      100      95

         Quiz:                 65        75        100      69        100      100      100      100      100

         Lab Reports:       80        90        85        80        85        90        85        100      100

         Midterm:            85

         Final:                 88

5. What is Tom's grade using the following grading scale? Refer to question 4.

Grade

PointRange

A+

100

A

90-100

B

80-89

C

70-79

D

60-69

F

0-59

Part 2

ANALYSIS ASSIGNMENT 2

1. The Chi-Square Test

Jury Selection (adapted from the Freedman, Pisani, Purves classic text)

One study of grand juries in Alameda County, California, compared the demographic characteristics of jurors with the general population, to see if jury panels were representative. The results for age are shown below. The investigators wanted to know if the 66 jurors were selected at random from the population of Alameda County. (Only persons over 21 and over are considered; the county age distribution is known from Public Health Department data.) The study was published in the UCLA Law Review.

Age

Count-wide %

# of jurors observed

# of jurors expected

(O-E)

(O-E)2/E

21-40

42%

5

 

 

 

41-50

23%

9

 

 

 

51-60

16%

19

 

 

 

over 60

19%

33

 

 

 

Total

100%

66

 

 

 

a) Should you do a test of homogeneity or a test of independence? Why?

b) Do we have evidence that grand juries are selected at random for the population of Alameda County?

2. Use MATLAB to generate a linear (1st Order) approximation for the population in the USA from 1986 to 2005.

3. Use MATLAB to generate a quadratic (2nd Order) approximation for the population in the USA from 1986 to 2005.

Population in the United States of America from 1986 to 2005.

Year

Population

1986

240,132,887

1987

242,288,918

1988

244,498,982

1989

246,819,230

1990

249,464,396

1991

252,153,092

1992

255,029,699

1993

257,782,608

1994

260,327,021

1995

262,803,276

1996

265,228,572

1997

267,783,607

1998

270,248,003

1999

272,690,813

2000

281,421,906

2001

285,317,559

2002

287,973,924

2003

290,788,976

2004

293,656,842

2005

296,410,404

Part -3: PROJECT

Pick one of the datasets on the CD-ROM that came with the new copy of the textbook. Data files are available in ASCII, Excel, Minitab, JMP, SAS, SPSS, and S-Plus formats. Alternatively, you can use any of the datasets of the PowerPoint presentations or Reading Materials.You must state in your project where your dataset came from. However, in either case make sure that the data is curvilinear and suitable for multiple regression.

1) Create a multiple regression model.

2) Formulate a null and alternative hypotheses.

3) Identify and explain the test statistic that will be used.

4) Run the Multiple Regression Software Tool to fully analyze the data and report its results.

5) Reject or do not reject your null hypotheses and explain why.

6) Accept or do not accept your alternative hypothesis.

7) Explain why your model is the best fit for the data.

Verified Expert

There were 3 parts in the assignment, each carrying some questions. I have solved all the questions in the assignment file itself. The solutions have been highlighted using yellow colour. Last solution required excel sheet analysis, so I have attached the same taking a sample data from my side.

Reference no: EM131463411

Questions Cloud

Create written work utilizing concepts of critical thinking : Create written work utilizing the concepts of critical thinking. Identify the informal fallacies, assumptions, and biases involved in manipulative appeals.
Differentiate deterministic and random variations : What is the difference between deterministic and random variations in the pattern of demands? Provide an example of a real problem in which predictable.
Analyze the challenges medicaid faces : Analyze the challenges Medicaid faces in terms of improving access to care, quality of care, and reducing the cost of care.
Determine the proportion of data points : Oakdale Furniture Company uses a special type of woodworking glue in the assembly of its furniture. During the past 36 weeks, the following amounts of glue.
Create a multiple regression model : ETCS 600 STATISTICAL APPLICATIONS FOR TECHNOLOGY - Determine the range, standard deviation, and variance for the indicated data set.
Explain a targeted audience within good health hospital : Identify a targeted audience within Good Health Hospital, and prepare implementation plan based on hypothetical meeting with hospital health care administrator.
Estimate mean and standard deviation of the weekly shipments : Rather than keeping track of each demand observation, Betty Sucasas, a member of the marketing staff with a large company that produces a line of switches.
Create the tasks for the trainer for your final project : Create tasks for the trainer for your final project. Using six structures listed in text, select one and specify how it relates to responsibilities of trainer.
Calculates a range of possible valuations : Calculates a range of possible valuations which prospective purchasers might make for the ordinary shares of the company

Reviews

Write a Review

Basic Statistics Questions & Answers

  A complete simple linear regression anlysis on the data

Refer to Exercise 2.97 (p. 106). The data in the value of 50 Beanie Babies collector's items, published in Beanie World Magazine, are reproduced on the next page. Can age (in months as of Sept. 1998) of a Beanie Baby be used to accurately pred..

  Calculate the variance of the number of breakdowns

Bill Russ, the production manager at Ross Co., maintains detailed records on number of times each machine breaks down and requires service all through the week. Bill records show that the Puret grinder has required repair service according to the ..

  Intercepts and linear equations word problems

Find the slope and vertical axis intercept of the linear function

  What is the difference between a sample and a census

What is the difference between a sample and a census? Why can it be advantageous to select a sample instead of carrying out a census?

  Suppose again that x2 follows a chi-square distribution

suppose that x2 follows a chi-square distribution with 19 degrees of freedom. compute px2 lessthanorequalto 20. round

  Why is a one-way anova an appropriate statistical procedure

Why is a one-way ANOVA an appropriate statistical procedure for this scenario? Has the assumption of equal variances been met?  Explain how you checked for this

  An april 15 2002 report in time magazine stated that the

an april 15 2002 report in time magazine stated that the average age for women to marry in the united states is now

  Whether the conditions hold for the sampling distribution

For each of the given situations, explain whether the conditions hold for the sampling distribution of P^1 - P^2 to be approximately normal:

  Corrective shoes or major dental work

What is the probability that an employee selected at random will need either corrective shoes or major dental work?

  Mean and standard deviation

In fact, the insurance company sees that in the entire population of homeowners, the mean loss from ?re is μ = $300 and the standard deviation of the loss is σ  = $400.

  In an analysis investigating the usefulness of pennies the

in an analysis investigating the usefulness of pennies the cents portions of 100 randomly selected credit card charges

  Estimating expected return and standard deviation

An analyst thinks that the economic conditions during the next year will either be Strong, Normal or Weak and she thinks that the Simpson Company's returns will have the following probability distribution.

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