Test 1 Excel Component

xlsx

School

Georgian College *

*We aren’t endorsed by this school

Course

101

Subject

Statistics

Date

Jan 9, 2024

Type

xlsx

Pages

Uploaded by DrMouseMaster1024

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

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

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

mber has a zero e, that's okay, ly the last 4 move the zero. copy and olour choices try to use one ptions or type rrectly, it will ata sets, r tions dy know h) in the he

Locations Frequency Background information: France 1522 2.201658777 You work at a food stand at W Poland 4036 95.09352457 One day your boss asks you to Mexico 3495 5.055317622 The data you gather is a list o United States 4919 7.114445786 Thailand 2806 4.058305312 Your Tasks: Italy 2667 3.85694665 Spain 2920 0.042224714 2. Create a pie chart, using eit Canada 1959 Hungary 3254 3. Answer the following questi China 4346 India 3409 Questions (5 marks): Turkey 310 Denmark 4753 Australia 5463 Egypt 6251 Germany 1197 United Kingdom 4355 Greece 1844 Netherlands 5392 Brazil 4244 Total 69143 Relative Frequency 1. Complete the frequency an in a Chart Sheet and NO 1. What country has the m 2. How could the food stan 3. What is the difference b

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Wasaga Beach during the summer. o do a survey of all the tourists in a month to see where they are visiting from of visitors from 20 different countries ther frequency - you pick, ions based on your results nd relative frequency chart using your data - 2 marks OT on this tab (must be properly labeled and be easy to read) - 3 marks most tourists at your food stand? (Explain why you think so) (2 marks) nd manager use the information from your results? (2 marks) between Frequency and Relative frequency? (1 mark)

Quarter Sales Background Information: 2018 Q1 You are the sales manager of Hasbro's Monopoly East 2018 Q2 You must present the data to the board at the next ex 2018 Q3 2018 Q4 Your Tasks: 2019 Q1 1. Using your data from the data sheet as the sales, 2019 Q2 2019 Q3 2. Answer the questions below as you would if you we 2019 Q4 2020 Q1 Questions (5 marks): 2020 Q2 2020 Q3 2020 Q4 2021 Q1 2021 Q2 2021 Q3 2021 Q4 2022 Q1 2022 Q2 2022 Q3 2022 Q4 Total create a histogram ( in a chart sheet, NOT this shee 1. What is the shape of your results? Be sure to 2. What decisions can the board make based off 2. Do you think your company is doing well or n

division. You have collected the sales for the last 4 years by quarter. xecutive meeting and provide any explanations for unusual sales. ere presenting this to the board et ) - label it appropriately - 5 marks o explain skewness or normally shaped data. (2 marks) ff of your chart? (1 mark) not? Explain. (2 marks)

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Flavours Total Sales Advertising Background Inform Laura's Chocolate 11,902 You are the marketi Old Fashioned Vanilla 17,272 amount of money s Strawberry 25,731 French and Frosted Mint 24,029 Your Tasks: Butter Pecan 13,202 Chocolate Chip Cookie Dough 17,622 Cookies n' Cream 16,258 Maple Taffy 19,094 3. Answer the quest Rum & Raisins 26,599 Salted Caramel & Chocolate 33,755 Questions (5 marks Bordeaux Cherries 11,184 Pistachio Almond 37,172 Pralines & Cream Dream 18,132 Super Kid 14,884 Bubble Gum 13,151 French Crisp 37,259 Orange Sherbet 27,947 Maple Walnut Fudge 31,866 Crunchy Chocolate Chip 12,078 Triple Chocolate Truffle 30,511 1. Using your data a 2. In that same shee (using the regr 1. Which item is y 2. What is the equ 2. What flavour re

mation: ing manager for Laura Secord's Central Ontario division. Using your sales by flavour, and th spent on advertising for that flavour, determine if there is a correlation. tions below from your results s): as Total Sales, create a scatter diagram in a new sheet. Label it properly, and show the line et ( which is NOT a chart sheet ), provide the correlation value ression, you may make another sheet for this) - 2 marks your explantory and which is your response variableand. How they are related fro uation of your line and how would you explain it to someone that does not unders equires more advertising (1 mark)

he of best fit - 3 marks om your regression. (2 marks) stand statistics. (2 marks)

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Test 1 Excel Component

Related Documents