Test 1 Excel Component

Instructio 1 Using the Data sheet tab, create your random data set using the questions I ask 2 3 Complete the three questions (one in each tab) 4 Save the file and close it 5 Go find the file location (where it is stored in your computer) and re-name it usin 6 Submit the file and go relax! Rules: 1 Do not hide or restrict any information or cells, if I find hidden cells (they are ver 2 You may use the descriptive statistics add in for excel 3 You may use any function or formulas you like from within excel, so long as they 4 You MUST answer the questions provided in each tab and they will be unique an 5 You must complete this file on your own using your own resources Once you have your data set, Copy and special paste the categorical data and q remaining sheets, note that you will be using the quantitative data set TWICE. Y

ons k and the instructions I gave you in the video ng the instructions on blackboard. : ry easy to find), your file will NOT be graded. y work and do what you need them to, they are okay nswers to your specific data set quantitative data as values into their respective locations in the You MUST know the difference between quantitative and categorical

RAW DATA RAW DATA 11323.44 1522.29 113 16812.63 4035.84 168 16212.97 3495.39 162 15219.59 4919.13 152 11557.02 2806.03 116 12859.56 2666.80 129 10067.41 2919.54 101 1694.65 1958.83 17 8413.14 3253.61 84 5153.55 4346.32 52 5321.65 3409.38 53 6958.27 310.21 70 15143.66 4752.54 151 12094.94 5463.26 121 4700.83 6251.29 47 17268.38 1197.03 173 16966.83 4355.22 170 1278.66 1843.71 13 13790.37 5392.37 138 8211.12 4244.08 82 QUANTITATIVE PASTE AS NUMBERS YOUR VALUES IN THE DATA COLUMNS WILL CHANGE OFTEN UNTIL YOU COP THEM INTO THE PASTE COLUMNS To special paste: Copy your data, RIGHT click on the first open cell below "a the "123 icon" this will paste your values as numbers and you can use

45 41 1929 18 9 17 23 58 2002 62 33 22 42 48 Rainbow 6 59 Colour Options 27 Red 58 Orange 57 Yellow 62 Green 30 Blue 1 Indigo Violet Pink Teal Rainbow CATEGORICAL PASTE AS NUMBERS The last 4 digits of your student Number the year you were born (this is 4 digits, EX 1982) Copy and paste your favourite colour from the chart below If your student num at the begining here just type it in exactl digits, and it will rem Be sure to ONLY c paste from the co below. Do NOT t outside these op (if you spell incor not work) PY AND SPECIAL PASTE as numbers" and chose e them in your file. When you have completed the da use them in their appropriate locat (you must alread when to use each tabs to answer th questions