Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q 1 The file Members.csv keeps track of a health club's data. It includes important dates regarding members, e . g . when the members

Q 1
The file Members.csv keeps track of a health club's data. It includes important dates regarding members, e.g. when the members toured the club ( before joining), and when they stopped their membership - denoted by visitDate and endDate.
We want to see if the amount of time between visit date and end date (in months) is significantly different between men and women. (Hint: Use a t-test to check whether this time length (term) is statistically different between men and women. Also, you will need to filter where status is inactive).
Q2
For the ORNG.csv daily adjusted closing prices:
a) Read these data into a DataFrame and augment the data with the daily returns of adjusted closing price.
b) Plot a histogram of the daily returns.
c) Calculate the skewness and kurtosis of the ORNG daily returns.
d) Determine using a statistical test if the daily returns follow a normal distribution (with 95% confidence).
e) Based on the standard deviation of the daily returns, identify those dates and returns that were smaller than -3 standard deviations or larger than +3 standard deviations. python solution for this

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beyond Big Data Using Social MDM To Drive Deep Customer Insight

Authors: Martin Oberhofer, Eberhard Hechler

1st Edition

0133509796, 9780133509793

More Books

Students also viewed these Databases questions

Question

How do Excel Pivot Tables handle data from non OLAP databases?

Answered: 1 week ago