This assignment is intended to provide you with experience using various functions$/$formulas in Excel to analyze a data set. You will perform the following similar activities:

$1.$ Enter and edit data

$2.$ Combine data columns

$3.$ Code data

$4.$ Sort data

$5.$ Construct contingency tables, bar charts, and histograms

Outcomes:

$1.$ Investigate Excel Menus

$2.$ Manipulate data within Excel

$3.$ Construct appropriate tables and graphs for qualitative and quantitative data.

$4.$ Analyze and interpret statistical output

$5.$ Generate a report.

Assignment Requirements:

Answer all questions listed in attached document $-$ Assignment Requirements.

Provide calculation method$/$formulas$/$functions$/$graphs and rationale used to arrive at an answer for each question; failure will result in zero mark for that question

Assignment should be written in a report form $($Title page, introduction to assignment, content page, answers to all questions, conclusion of assignment, citation if applicable, proper formate$/$spacing etc.$).$ Failure to follow report format will result deduction in your marks

Convert assignment into pdf formate and upload only one pdf document on eConestoga

Optional practice: You are encouraged $-$ though not mandatory $-$ to consult attached instruction $-$ Descriptive Stats Tables and Graphs. It will be helpful to understand the process of analyzing data using Excel's functions

Caution: Per Conestoga$$s Plagiarism policies; both the copier and the person allowing the copying will receive a zero. If a second offence occurs, then all labs will be marked zero for both students.