Data Analysis Report on Market Research

Running head: DATA ANALYSIS REPORT ON MARKET RESEARCH
Data Analysis Report On Market Research
Name of the Student:
Name of the University:
Author Note:

1DATA ANALYSIS REPORT ON MARKET RESEARCH
Table of Contents
Introduction......................................................................................................................................2
Data Analysis...................................................................................................................................2
Response to Question 1...............................................................................................................2
Response to Question 2...............................................................................................................2
Response to Question 3...............................................................................................................3
Response to Question 4...............................................................................................................4
Response to Question 5...............................................................................................................5
Response to Question 6...............................................................................................................6
Response to Question 7...............................................................................................................7
Summary..........................................................................................................................................8
References........................................................................................................................................9

2DATA ANALYSIS REPORT ON MARKET RESEARCH
Introduction
The purpose of this report is to provide a detailed analysis on the survey data based on
the beverages consumption between domestic students and international students of USC
University to understand the preference of beverages among thousands of students of the
university. The analysis is performed after selecting a random sample of 90 students. The
consumption of beverages is measured with reference to 375ml cans. In this paper, the most
preferred beverages have been chosen for total students and for local and international students
separately.
Data Analysis
All the given requirements are addressed in the course of this study. The dataset is given
in the Excel sheet with 200 responses. The random numbers were already calculated using
RAND() function in Excel (Mélard 2014). Firstly, the random sample of size 90 is drawn by
doing customised sorting of the random numbers.
Response to Question 1.
The proportions of both local and international students are shown in the tabular form
below:
Proportion of local students 0.911111
Proportion of international students 0.088889