Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Applied Statistics Expert

a. Create a histogram of the weekly operating profits from the prior year of operation, using 6 equal sized bins. What is the mode on the histogram? How would you define it? Which probability distribution does the histogram resemble? (You may wish to use the Excel file Harvey's Case.xls at the Gateway web site.)

b. What was the average weekly profit for the prior 12-month period? Determine and define the variance and standard deviation of weekly profit.

c. How confident are you of this estimate? Calculate a 99% confidence interval for weekly profits, assuming that sigma is unknown. What does this tell you about weekly profits?

d. Based on the above, what is the expected exposure on the lost profits claim? To formally test Mr. Cooper's claim, test to see if there was a significant difference in mean weekly profits between the first 6 months of the year and the last 6 months. Use a 0.05 significance level and assume equal variances.

Does this support Mr. Cooper's claim? b. Having thought about Mr. Cooper's suggestion, you consider several options as an estimate of lost profits.

These include

1) the full year,

2) the last six months only,

3) a weighted average that gives twice the weight to the last six months as to the first six months, or

4) some other weighted average.

Which method do you think gives the most accurate estimate of lost profits?

Attachment:- harveys-tree-farm-data.xls

Applied Statistics, Statistics

  • Category:- Applied Statistics
  • Reference No.:- M92760423
  • Price:- $30

Guranteed 24 Hours Delivery, In Price:- $30

Have any Question?


Related Questions in Applied Statistics

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 ...

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 analytics and statistics research reportthis

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 presentat ...

Business statistics assignment -the purpose of this

Business Statistics Assignment - The purpose of this assignment is to improve your understanding in choosing between and using methods to assess the relationship between variables and make comparisons across different se ...

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 ...

Business data analysis facts from figures assignment

BUSINESS DATA ANALYSIS: FACTS FROM FIGURES Assignment - Question 1 - Private capital expenditure for 12 successive quarters are presented in the following table: Quarter Millions 1 31,920 2 25,120 3 30,350 4 24,650 5 30, ...

Business statistics project assignment -there will be two

BUSINESS STATISTICS PROJECT ASSIGNMENT - There will be two parts to this assignment: Part A: Group Work (A Business Report) Part B: Individual Reflective Piece (A Ministerial Brief) The response to Part A must be provide ...

Business data analysis computer assignment -part 1

Business Data Analysis Computer Assignment - PART 1 - Economists believe that high rates of unemployment are linked to decreased life satisfaction ratings. To investigate this relationship, a researcher plans to survey a ...

Linear project instructions -curve-fitting project - linear

Linear Project instructions - Curve-fitting Project - Linear Model For this assignment, collect data exhibiting a relatively linear trend, find the line of best fit plot the data and the line, interpret the slope, and us ...

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 ...

  • 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