Reference no: EM132523640

FIN10002 Financial Statistics - Swinburne University of Technology

Assessment details

You will need to download the Excel dataset ‘Major Assignment data Movie Downloads.xlsx' from Canvas. The data set contains customer details and the types of movies downloaded from an internet site for a given year. There are 4815 customers in this data set and eight variables as follows:

1. Customer No: is the customers number for this set
2. State: the state of residence of customer
3. City: city of residence
4. Gender: M = Male, F = female
5. First choice: Type of movie category (Action, Comedy, Drama and SciFi)
6. Second Choice: Second choice of movie category
7. Age: age of customer
8. Purchases: Number of purchases
9. DollarAmt: Total amount of purchases in dollars

You will use this data set to generate responses to the following six tasks.

1. Select a random sample

Select a random sample of size 60 customers from the 4815 customers in the Major Assignment data Movie downloads file. You will use this sample data to complete tasks 2 to 6.

2. Descriptive statistics

Use data summary methods to describe the returns in your sample using seven variables - items 2 to 9 above. (Note: Do NOT do Customer No) Use an appropriate graphical and summary statistical technique, chosen according to the type of variable (note that less appropriate/inappropriate techniques will receive fewer/no marks). Choose your techniques from:

Tabular Techniques: frequency tables and grouped frequency tables Summary Statistics: mode, median, mean, standard deviation, range, coefficient of variation and interquartile range
Graphical Techniques: pie chart, bar graph, histogram, frequency polygon.
(See topics 1 and 2)

Do not draw an ogive curve, stem plot, or a box plot in this assignment and do not draw 3-D graphs.

1. For a nominal or an ordinal variable draw a graph and present a frequency table in percentages.
2. For a ratio or an interval, variable draw a graph and a summary statistics table, including summary statistics appropriate to the type of distribution only.
3. Try to use variation in drawing graphs e.g. pie chart/bar chart or histogram/polygon.
4. Do not draw two different graphs for the same variable. You can draw the same type of graph for two variables.
5. Do not include any information that you will not include in your discussion such as kurtosis.
6. Display and describe one variable at a time.

3. Confidence intervals

Estimate the following quantities, using 95% confidence intervals. Explain the meaning of your confidence intervals.

a. The average number of purchases for first choice SciFi movies only
b. The average dollar amount spent for all type of movies.

Compare both intervals with their respective true means by calculating the actual population mean for the full 4815 customers, and comparing the true population mean to the sample mean and confidence interval (note: it is not usual to do this, so you are asked to do this for the purpose of this assignment).

Your confidence interval should start with ‘We are 95% confident that...". This section should take half a page or less.

NB: Please make sure you provide sufficient information in the appendix for your confidence interval calculations to be replicated, so they can be checked.

4. Hypothesis testing

1. It is often felt that the average amount spent (in $) for first choice Comedy is more than the average for first choice Drama movies. Investigate this contention by carrying out an appropriate hypothesis test.

2. It is often felt that the average purchases, differs for males and females. Use gender for this test.

Only report a non-technical explanation of your methodology and your findings in the main section of the report. The computations and output should be placed in an appendix, including the test statistic, p-value and degrees of freedom. This should take half a page or less.

5. Correlation and regression

In this section, you will investigate the relationship between age and the dollar amount spent. Using these two variables (age and Dollars spent) develop a regression model to predict dollars spent from the age of the customer. Make sure that you undertake a full regression analysis, with appropriate discussion and include:

1. a scatterplot and a brief discussion
2. an estimate of the linear regression model
3. the coefficients of correlation and determination
4. a test of the hypothesis that there is no linear relationship
between age and the dollar amount spent.

Ensure your scatterplot includes a line of best fit. Also, make sure you describe the relationship between the variables using R and R-square and interpret the slope, coefficients and the results of the hypothesis test. Use a significance level of 0.05.

6. Conclusion

Provide a brief, concise summary of all of your findings and briefly mention any limitations in your findings.
Make sure you do not give tables or graphs here.

Attachment:- Financial Statistics.rar