PLEASE USE THESE VARIABLES BASED ON IPHONE VS ANDROID USERS:
Variable Quantitative/Qualitative Level of Measurement
Country Qualitative Nominal
Age Group Qualitative Ordinal
Gender Qualitative Nominal
Operating System Qualitative Nominal
Usage Duration Quantitative Continuous
User Satisfaction Quantitative Discrete Ordinal
Suppose you want to analyze a particular topic that is of interest to you. To study the topic, you will have to first collect data using sources available to you (for example, surveys, books, open data banks available online, etc.). Collect reliable data to create a data set that has at least six variables (columns) and at least 35 entries. The variables in your data set should satisfy the following:
There should be at least three qualitative variables (Note that there should be at least one nominal level of measurement and at least one ordinal level of measurement), and at least three quantitative variables with a minimum of one continuous variable and at least one discrete variable.
Open an Excel workbook and in the worksheet, enter the following information,
The topic of Interest/Title –
Brief description of what you are planning to study or the objective of picking this topic (Your description should be at least 100 words in length) –
Title of Data Set –
Variables used and their detailed descriptions (for example if you choose “weight” as a variable, what does weight represent? It can be the weight of player, weight of an animal etc.) –
List of sources from where your data was collected –
Rename this worksheet as “Description of Dataset”
TASK 2
To your existing Excel workbook add a new worksheet and name the worksheet as “DataSet.”
In this sheet, you will be collecting and entering the raw data for the topic you selected. The raw dataset should have at least 35 data entries and each data entry should have at least five variables as mentioned in TASK 1 .
