Get 20% Off + $20 Signup Bonus ! Limited Time, Hurry !
Get 20% Off + $20 Signup Bonus ! Limited Time, Hurry !
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

11 Pages
Data analytics

 This is data analytics assignment and the total word count is 2000. > Variables: Independent variables: Trust and Social paricipation Dependent variables: Quality of health care > Aim : Ai ...

Type

Course Work

Subject

Statistics

8 Pages
BUS708 Statistics and Data Analysis

There are two datasets involved in this assignment: Dataset 1 and Dataset 2, which are the same datasets used in the first assignment(Assessment 3, Excel Report). Please refer to Assessment 3 Descript ...

Course

BUS708

Type

Course Work

Subject

Statistics

University

ACS Distance Education

8 Pages
ECON940 Statistics For Decision Making

Task: Assignment Tasks:1. Visually present data for the prices based on gender of the product. Calculate descriptive summary measures for the prices based on gender of the product. Comments on the ...

Course

ECON940

Type

Course Work

Subject

Statistics

University

University of Wollongong

259 Pages
HOW001 Statistical Analysis

Question: The purpose of this assignment is to provide a rough draft of a section of your analysis paper so that you can receive feedback on your methods. It should include the following: 1.  ...

Course

HOW001

Subject

Statistics

University

University of Washington

GBU41501 Business Data Analysis

Question

Answered

Question:

· All numerical calculations and graphs/plots should be done using EXCEL. In your worksheet there should be formula’s and/or calculations and not just the value results. If there are no calculations showing how you obtained the result, 0 marks will be given even if the result is correct.

· Please DO NOT use the formulas embedded in excel (unless explicitly specified otherwise!) but the ones we discussed on the slides in class to calculate the parameters (you can of course check your result with the excel functions):

· Your assignment must be done in Excel and for every question you will make a separate worksheet! There are 5 questions so there will be 5 worksheets in your excel file, not more not less!

· A copy of your completed assignment, so your EXCEL sheets, must be submitted electronically.

· You are required to keep a hard copy and an electronic copy of your submitted assignment to re-submit, in case the original submission is lost for some reason

Attached you will find an Excel sheet named “financial_markets_data.xlsx” in which you will find the daily closing prices of both the S&P500 (USA benchmark index) and of the DJ Eurostoxx 50 (European benchmark index) over the last 5 years.

a. Calculate the daily returns for both indices and then the mean and the median of these daily returns for both indices

b. Calculate the standard deviations, variances and coefficient of variances of the daily returns for both indices and also for the daily closing prices of both indices.

c. Calculate the following percentiles for the daily returns for both indices: 10th, 25th and 40th .

d. What is the correlation between the closing prices of the S&P500 and of the DJ Eurostoxx 50?

e. Divide the daily returns from both indices into a number of different classes you deem appropriate. Explain why and how you did this. Give per class the frequency, relative frequency and cumulative relative frequency.

f. Plot a histogram of the daily returns of both indices and comment on the shape of it.

In the attached spreadsheet named “Accidental_Drug_Related_Deaths_2012-2018.xlsx” you will find data on the all the deaths in the state of Connecticut (USA) during the period 2012- 2018. You found on internet that the population in this American state is composed of 69.3% Whites, 16.1% Hispanics, 10.1% Black or Afro-Americans and 4.5% Asians. Further you assume that the population is exactly 50% male and 50% female.

a. What is the average and median age of the deaths per race and per gender? What is the standard devation of the age per race and per gender?

b. You want to know whether there are significantly (95% confidence level) more malesn in Connecticut dying from drug abuse than females following the Hypothesis testing we learned in class. What would be your null hypothesis and what your alternative hypothesis?

c. Verify for b above wether your nul hypothesis should be withheld or rejected.

d. Perform the same analysis whether there are significantly (95% confidence level) more Blacks dying from drug abuse than their share in the population would suggest. Specify clearly your null hypothesis and your alternative hypothesis.

e. Perform the same analysis whether there are significantly (95% confidence level) more Hispanics dying from drug abuse than their share in the population would suggest. Specify clearly your null hypothesis and your alternative hypothesis.

f. Perform the same analysis whether there are significantly (95% confidence level) more Whites dying from drug abuse than their share in the population would suggest. Specify clearly your null hypothesis and your alternative hypothesis.

Life insurance experts have been claiming that the average worker in the city of Cincinnati has no more than $25,000 of personal life insurance. An insurance researcher believes that this is not true and sets out to prove that the average worker in Cincinnati has more than  $25,000 of personal life insurance. To test this claim, she randomly samples 100 workers in Cincinnati and interviews them about their personal life insurance coverage. She discovers that the average amount of personal life insurance coverage for this sample group is $26,650. The population standard deviation is $12,000.

a. Determine whether the test shows enough evidence to reject the null hypothesis posed by the salesperson. Assume the probability of committing a Type I error is .05.

b. If the actual average for this population is $30,000, what is the probability of committing a Type II error?

c. If instead you were testing a null hypothesis stating that the average of the population is $25,000 against an alternative hypothesis that it is not equal to $25,000, where would the critical values lie assuming an 10% ?

d. Explain the meaning of the critical values obtained under c. above and how you would use these in hypothesis testing.

a. What is the covariance between dependent variable Y and the independent variable X? What are the standard deviations of X and Y in this sample?

b. What is the correlation between X and Y and give your interpretation of this figure.

c. Find the equation of the regression line of X and Y and interpret the values you found for the intercept and the slope.

GBU41501 Business Data Analysis

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

155 More Pages to Come in This Document. Get access to the complete answer.

MyAssignmenthelp.com is one of the leading urgent assignment help providers in the USA. We have earned our reputation as best assignment help in multiple countries including the USA. We have designed unique fastest delivery options, which assist us to deliver immediate assignment assistance. Our teams of highly skilled qualified writers are capable of delivering fast assistances. We provide online assignment help to a wide range subjects so that whenever students face the urgent need of assignment help, they can hire our assistance within a short period.

More GBU41501 GBU41501 Business Data Analysis: Questions & Answers

Q

Data analytics

 This is data analytics assignment and the total word count is 2000. > Variables: Independent variables: Trust and Social paricipation Dependent variables: Quality of health care > Aim : Aim should be in one statement and The aim of the study should be clear, focused and should indicate t ...

View Answer
Q
icon

We aren't endorsed by this University

BUS708 Statistics and Data Analysis

There are two datasets involved in this assignment: Dataset 1 and Dataset 2, which are the same datasets used in the first assignment(Assessment 3, Excel Report). Please refer to Assessment 3 Description for the details about these datasets. All data processing and calculation should be performed in ...

View Answer
Q
icon

We aren't endorsed by this University

ECON940 Statistics For Decision Making

Task: Assignment Tasks:1. Visually present data for the prices based on gender of the product. Calculate descriptive summary measures for the prices based on gender of the product. Comments on the location, shape and variability of those distributions.2. Visually present data for the prices based ...

View Answer
Q
icon

We aren't endorsed by this University

HOW001 Statistical Analysis

Question: The purpose of this assignment is to provide a rough draft of a section of your analysis paper so that you can receive feedback on your methods. It should include the following: 1. Short description of your research question 2. Statement of the dataset you will use to answer ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?