Can you help me understand the FREQUENCY FORMULA on Google Spreadsheets? ANSWER: Definitely – I made a video explaining how to use the frequency formula and what it means; what the output represents! It is wonderful to understand the values you are receiving from the […]
Category: GOOGLEDOCS HELP
Can you help me go from a decimal to a rounded percent on Google Spreadsheets?
Can you help me go from a decimal to a rounded percent on Google Spreadsheets? ANSWER: Of course! You can look in the toolbar of the spreadsheet and select the % icon! This will change the decimal into a percent for you. Then you will […]
How can I move a chart to its own sheet? (Just images instead of a video – older post)
How can I move a chart to its own sheet? Answer: You click on the chart and will see a drop down menu on the top right corner. Select “Move to Own Sheet”.
How do you get the legend to be correct without editing it after the chart shows up?
How do you get the legend to be correct without editing it after the chart shows up? ANSWER: So, in the last few years Google does make it a bit tricky to edit legends in charts for some reason. One quick solution is to write […]
I’m having rounding issues using Google Spreadsheets, like 12.50% is 1250% in Module 2. Help, please.
I’m having rounding issues using Google Spreadsheets, like 12.50% is 1250% in Module 2. Help, please. ANSWER: Google Spreadsheet decided that for your spreadsheet you wanted a percent as the final answer so it already multiplied by 100 for you. This happens sometimes and you […]
Where are the assignments, like the first spreadsheet assignment?
Where are the assignments, like the first spreadsheet assignment? ANSWER: Right on our Blackboard course site. You will find spreadsheet assignments in each module folder (first spreadsheet assignment in Module 1 folder). You will find it in the All-in-One Page or in the Spreadsheet folder. […]
Help with finding p-values in ANOVA
Help with finding p-values in ANOVA ANSWER: I made two videos of how to get the correct p-value using Module 7 Spreadsheet Assignment’s information. You can use the ANOVA calculator that is in Module 7 or you can use Google Spreadsheets directly with an Add-On: […]
Google just updated its chart editor so I need help with Module 3 Spreadsheet Assignment!
Google just updated its chart editor so I need help with Module 3 Spreadsheet Assignment! ANSWER: I love how Google likes to improve all the time but sometimes it happens when you least expect it. No worries! Now… if you want to figure out the […]
I am not an FIT student taking your course, what should I do?
I am not an FIT student taking your course, what should I do? Every student for the course is given an FIT email address. This way you can do the work. If you do not know the password for your FIT email, or don’t know […]
The averages are not showing up in my chart for Module 7! Help!
The averages are not showing up in my chart for Module 7! Help! ANSWER: If you already made your chart and only one dot color is showing up then no worries. Click ADVANCED EDIT. I am going to show you with a student’s chart without […]