Topic: Excel Project
Subject: Business Analytics
,DATA
Data are collected observations or measurements represented as text, numbers, or multimedia.
Data can be broadly categorized as qualitative or quantitative.
Quantitative data can be expressed as a number and counted or compared on a numerical scale this would
include such things as reading skills from surveys, temperatures observed, or measurements gathered.
Qualitative data include things like textual descriptions of events, maps, pictures or transcripts.
Dataset refers to a collection of data about a particular subject.
The data for each subject is recorded as an entry for each of the attributes that can describe the subject.
Analysis of data based on its attributes whether they are categorical, interval or ratio data.
❖ Interval data: Order Date.
❖ Categorical data: Region, Representative, Item.
❖ Ratio data: Units, Unit cost and Total sales.
, excel
Microsoft Excel is a software program produced by Microsoft Corporation that allows users to organize
format and calculate data using formulas within the spreadsheet system. So key terms are organizing your
data formatting, and then calculate.
Excel is a commercial spreadsheet application produced and distributed by Microsoft for Windows and
Mac operating systems, and features the ability to perform basic calculations, use graphical tools, create
pivot tables, and macro programming languages.
Subject: Business Analytics
,DATA
Data are collected observations or measurements represented as text, numbers, or multimedia.
Data can be broadly categorized as qualitative or quantitative.
Quantitative data can be expressed as a number and counted or compared on a numerical scale this would
include such things as reading skills from surveys, temperatures observed, or measurements gathered.
Qualitative data include things like textual descriptions of events, maps, pictures or transcripts.
Dataset refers to a collection of data about a particular subject.
The data for each subject is recorded as an entry for each of the attributes that can describe the subject.
Analysis of data based on its attributes whether they are categorical, interval or ratio data.
❖ Interval data: Order Date.
❖ Categorical data: Region, Representative, Item.
❖ Ratio data: Units, Unit cost and Total sales.
, excel
Microsoft Excel is a software program produced by Microsoft Corporation that allows users to organize
format and calculate data using formulas within the spreadsheet system. So key terms are organizing your
data formatting, and then calculate.
Excel is a commercial spreadsheet application produced and distributed by Microsoft for Windows and
Mac operating systems, and features the ability to perform basic calculations, use graphical tools, create
pivot tables, and macro programming languages.
