logo

Quantitative Analysis of Customer Data for Movie Downloads

Produce a report by generating responses to six tasks using Excel to generate statistical output.

14 Pages3218 Words354 Views
   

Added on  2023-06-03

About This Document

This report presents a quantitative analysis of a sample of 50 customers randomly selected from 4815 customers for movie downloads. The report utilizes various quantitative methods to present the results of the analysis conducted with the help of Microsoft Excel. The descriptive statistics of the variables are presented in tables as well as charts such as pie charts, bar charts, and histograms. The tests of hypothesis are done using t-tests and the results presented in the appendices.

Quantitative Analysis of Customer Data for Movie Downloads

Produce a report by generating responses to six tasks using Excel to generate statistical output.

   Added on 2023-06-03

ShareRelated Documents
1
FIN10002: Financial Statistics
Assessment 2: Report
By Student’s Name
Tutors Name
Date
Quantitative Analysis of Customer Data for Movie Downloads_1
2
Executive Summary
The purpose of this report is to highlight a quantitative analysis of a sample of 50
customers randomly selected from 4815 customers given.
This report utilizes various quantitative methods to present the results of the analysis conducted
with the help of Microsoft Excel. The descriptive statistics of the variables are presented in tables
as well as charts such as pie charts, bar charts, and histograms. The tests of hypothesis are done
using t-tests and the results presented in the appendices.
Some of the main findings are that the average dollar amount for all types of movies of the
population was between $141.47 and $187.77 at 95% confidence level. The population mean of
purchases for first choice SciFi movies only was found to be between 28.20 and 39.94 at 95%
level of confidence. it was found the average dollar amount spent for first choice comedy movies
is not more than the average dollar amount spent for first choice drama movie. Moreover, there
was difference in the average purchases for males and females. The regression analysis indicated
that there was no linear relationship between the age of customers and the dollar amount spent on
all type of movies.
Quantitative Analysis of Customer Data for Movie Downloads_2
3
Table of Contents
Executive Summary ........................................................................................................................ 2
Introduction ..................................................................................................................................... 4
Analysis........................................................................................................................................... 4
Descriptive Statistics ................................................................................................................... 4
Confidence intervals ................................................................................................................... 8
Hypothesis Testing...................................................................................................................... 8
Hypothesis 1............................................................................................................................ 8
Hypothesis 2............................................................................................................................ 8
Correlation and Regression ......................................................................................................... 8
Scatterplot ............................................................................................................................... 9
Linear regression ..................................................................................................................... 9
Coefficients of Correlation and Determination....................................................................... 9
Hypothesis 3.......................................................................................................................... 10
Conclusion .................................................................................................................................... 10
Appendices .................................................................................................................................... 11
Appendix A: Random Sample .................................................................................................. 11
Appendix B: Descriptive Statistics ........................................................................................... 12
B1: Statistical Summary for the Age of Customers .............................................................. 12
B2: Statistical Summary for the Purchases ........................................................................... 12
B3: Statistical Summary for the Dollar Amount Spent ........................................................ 13
Appendix C: Hypothesis tests ................................................................................................... 13
C1: Female and male purchases differ .................................................................................. 13
C2: First choice Comedy and First choice Drama differ in dollar amount spent ................. 14
Appendix D: Regression Model................................................................................................ 14
Quantitative Analysis of Customer Data for Movie Downloads_3
4
Introduction
A random sample of 50 customers was selected from a population 4,815 customers in a
data set that contains customer details and the types of movies downloaded from an internet site
for a given year. The data set has eight variables:
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
This report uses descriptive statistics to describe a statistical summary of all the variables.
Further analysis was done to establish the average dollar amount spent on all types of movies and
the average number of purchases for the first choice SciFi movies only. Tests of hypothesis was
also carried out to determine whether the average number of purchases differed for males and
females. The other hypothesis tested was whether the average dollar amount spent for first
choice comedy movies was more than the average spent for first choice drama movies. Finally, a
full regression analysis was performed to investigate the linear relationship between the age of
customers and the total dollar amount spent.
Analysis
A random sample of 50 customers was extracted from a population of 4,815. Below is a
discussion of the sample statistics.
Descriptive Statistics
Of the eight states represented in the sample, 36% of the customers are located in FL
while only 6% are from LA.
0%
5%
10%
15%
20%
25%
30%
35%
40%
AZ CA CO FL IL IN LA
Frequency
State
Barchart of State
Quantitative Analysis of Customer Data for Movie Downloads_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Statistical Analysis of Movie Downloads from an Internet Site
|18
|1986
|65

Analysis of 2014 Taxation Returns in Australia
|19
|2999
|272

FINANCIAL STATISTICS TABLE OF CONTENTS Executive summary 3 INTRODUCTION 3 (2) DEscriptive statistics of the variables 3 (3) Calculation of average age and transaction dollar 3 (4) Evaluation of linear
|12
|2726
|208

Investigative Statistics
|10
|1267
|490

Investing Method
|11
|1187
|244

Evaluation of behavior of customers in using online store
|10
|992
|136