Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Applied Statistics Expert

Assignment Questions -

Q1. Part of an ANOVA table is shown below.

Source of Variation

Sum of Squares

Degree of Freedom

Mean Square

F

Between treatments

90

3

?

?

Within treatments (Error)

120

20

?

 

Total

?

?

 

 

a. Compute the missing values and fill in the blanks in the above table. Use α = .01 to determine if there is any significant difference among the means.

b. How many groups have there been in this problem?

c. What has been the total number of observations?

Q2. The sales records of a major auto manufacturer over the past 10 years are shown below.

Year (t)

Number of Cars Sold (in 1000s of Units)

1

195

2

200

3

250

4

270

5

320

6

380

7

440

8

460

9

500

10

500

Develop a linear trend expression and project the sales (the number of cars sold) for time period t = 11.

Q3. The following data represent the number of flash drives sold per day at a local computer shop and their prices.

Price (x)

Units Sold (y)

$34

3

36

4

32

6

35

5

30

9

38

2

40

1

a. Perform an F test and determine if the price and the number of flash drives sold are related. Let α = .01.

b. Perform a t test and determine if the price and the number of flash drives sold are related. Let α = .01.

Q4. In a completely randomized experimental design, 14 experimental units were used for each of the five levels of the factor (i.e., five treatments). Fill in the blanks in the following ANOVA table.

Source of Variation

Sum of Squares

Degree of Freedom

Mean Square

F

Between treatments

?

?

800.00

?

Within treatments (Error)

?

?

?

 

Total

10,600

?

 

 

Q5. Halls, Inc. has three stores located in three different areas. Random samples of the sales of the three stores (In $1,000s) are shown below.

Store 1

Store 2

Store 3

46

34

33

47

36

31

45

35

35

42

39

 

45

 

 

At a 5% level of significance, test to see if there is a significant difference in the average sales of the three stores.

Q6. The marketing department of a company has designed three different boxes for its product. It wants to determine which box will produce the largest amount of sales. Each box will be test marketed in five different stores for a period of a month. Below is the information on sales.

 

Store 1

Store 2

Store 3

Store 4

Store 5

Box 1

210

230

190

180

190

Box 2

195

170

200

190

193

Box 3

295

275

290

275

265

a. State the null and alternative hypotheses.

b. Construct an ANOVA table.

c. What conclusion do you draw?

Q7. Three different brands of tires were compared for wear characteristics. For each brand of tire, 10 tires were randomly selected and subjected to standard wear testing procedures. The average mileage obtained for each brand of tire and sample standard deviations (both in 1000 miles) are shown below.

 

Brand A

Brand B

Brand C

Average mileage

37

38

33

Sample variance

3

4

2

Use the above data and test to see if the mean mileage for all three brands of tires is the same. Let α = .05

Q8. John has collected the following information on the amount of tips he received from parking cars the last seven nights.

Day

Tips

1

18

2

22

3

17

4

18

5

28

6

20

7

12

a. Compute the three-day moving averages for the time series.

b. Compute the mean square error for the forecasts.

c. Compute the mean absolute deviation for the forecasts.

Q9. The Very Fresh Juice Company has developed a regression model relating sales (y in $10,000s) with four independent variables. The four independent variables are price per unit (x1, in dollars), competitor's price (x2, in dollars), advertising (x3, in $1000s), and type of container used (x4) (1 = Cans and 0 = Bottles). Part of the regression results is shown below.

Source of Variation

Degree of Freedom

Sum of Squares

Mean Square

F

Regression

4

283,940.60

 

 

Error

18

621,735.14

 

 

Total

 

 

 

 

a. Compute the coefficient of determination and fully interpret its meaning.

b. Is the regression model significant? Explain what your answer implies. Let α = .05.

c. What has been the sample size for this analysis?

Q10. The prices of Rawlston, Inc. stock (y) over a period of 12 days, the number of shares (in 100s) of the company's stocks sold (x1), and the volume of exchange (in millions) on the New York Stock Exchange (x2) are shown below.

Day

(y)

(x1)

(x2)

1

87.50

950

11.00

2

86.00

945

11.25

3

84.00

940

11.75

4

83.00

930

11.75

5

84.50

935

12.00

6

84.00

935

13.00

7

82.00

932

13.25

8

80.00

938

14.50

9

78.50

925

15.00

10

79.00

900

16.50

11

77.00

875

17.00

12

77.50

870

17.50

Excel was used to determine the least squares regression equation. Part of the computer output is shown below.

ANOVA

 

df

SS

MS

F

Significance F

Regression

2

118.8474

59.4237

40.9216

0.0000

Residual

9

13.0692

1.4521

 

 

Total

11

131.9167

 

 

 

 

 

Coefficients

Standard Error

t Stat

P-value

Intercept

118.5059

33.5753

3.5296

0.0064

(x1)

-0.0163

0.0315

-0.5171

0.6176

(x2)

-1.5726

0.3590

-4.3807

0.0018

a. Use the output shown above and write an equation that can be used to predict the price of the stock.

b. Interpret the coefficients of the estimated regression equation that you found in part (a).

c. At 95% confidence, determine which variables are significant and which are not.

d. If on a given day, the number of shares of the company that were sold was 94,500 and the volume of exchange on the New York Stock Exchange was 16 million, what would you expect the price of the stock to be?

Need it as per the guidelines.

Applied Statistics, Statistics

  • Category:- Applied Statistics
  • Reference No.:- M92629203
  • Price:- $90

Guranteed 48 Hours Delivery, In Price:- $90

Have any Question?


Related Questions in Applied Statistics

Using minitab to construct linear regression modelsscatter

Using Minitab to Construct Linear Regression Models Scatter Plot To obtain a simple scatter plot using Minitab: One of the first steps in the analysis of the study data is to create a scatter plot that compares the quant ...

Business statistics assignment -quiz 1 -question 1 - a

Business Statistics Assignment - Quiz 1 - Question 1 - A study is under way in the Otway National Park to determine the mature height of Mountain Ash gum trees. Specifically, the study is attempting to determine what fac ...

The scientific method assessment task - data analysis

The Scientific Method Assessment Task - Data Analysis Assignment QUESTION 1 - Single-factor experiments Use Minitab for this question. The data in Q1 tab of 60902_AssessmentTask3Data_Spring2018.xlsx records blood cholest ...

Business analytics and statistics research report -this

Business Analytics and Statistics Research Report - This assignment is based on fictional data. You are creating a business report for the CEO of a retail company called, Athlete Panda. It must be professional in present ...

Assignment -in this assignment ms excel must be used to

Assignment - In this assignment MS Excel must be used to perform any calculations/graphical presentations as required in this assignment. Question 1 - Below you are given the examination scores of 20 students (data set a ...

Business statistics project -problem description the

BUSINESS STATISTICS PROJECT - Problem Description: The blockchain is a decentralized ledger of all transactions across a peer-to-peer network. Using this technology, participants can confirm transactions without a need f ...

You are expected to work in groups and write a research

You are expected to work in groups and write a research report. When you work on your report, you need to use the dataset, and other sources such as journal articles. If you use website material, please pay attention to ...

Analysis - comparing group means background and objectives

Analysis - Comparing group means Background and objectives - The balance_FALL17.xlsx dataset represents data from a fictitious study that explores the impact of two different interventions designed to help elderly client ...

Assignment - research topicpurpose the purpose of this task

Assignment - Research topic Purpose: The purpose of this task is to ensure you are progressing satisfactorily with your research project, and that you have clean, useable data to analyse for your final project report. Ta ...

Go to the website of ahrqs website titled advances in

Go to the website of AHRQ's website titled Advances in Patient Safety: From Research to Implementation located in the Webliography and select a specific research article. Bring back to the class, at minimum, the followin ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As