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 […]
Category: ASSIGNMENTS
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. […]
Using Google Spreadsheets, how can you tell the strength and sign of an association?
Using Google Spreadsheets, how can you tell the strength and sign of an association? ANSWER: The fastest way is to find the “r” using the spreadsheet formula “=correl(____, _____)” . r < 0 : If you have a negative result then you have a negative […]
How do you “Find the number of data values”?
How do you “Find the number of data values”? ANSWER: You are being asked to tell me how many data values there are in the set. This is referred to as the COUNT. For example, Find the number of data values in the following: 4, […]
Please help me find the area under the curve to the right of z = -.65
Please help me find the area under the curve to the right of z = -.65 ANSWER: Sure! I made a video that is less than 3 minutes to explain how to do this. Area under the curve to the right of z = -.65
Can you help tell me what the Z value with 65% of the data to the right of it is?
Can you help tell me what the Z value with 65% of the data to the right of it is? ANSWER: YES! I made a video that is less than 3 minutes to explain how to do this. Z value with 65% of the data […]
I Can’t Figure Out How to Review Old Homework/Quizzes on Blackboard – HELP!
I Can’t Figure Out How to Review Old Homework/Quizzes on Blackboard – HELP! ANSWER: A student got back to me with this response after they contacted the Open SUNY Help Desk (thank you). They explained how to review past quizzes and homework’s in this way: […]
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: […]
Why do we pick z = .52 instead of z = .53 or something else when you have the left tail area of 70%??
Why do we pick z = .52 instead of z = .53 or something else when you have the left tail area of 70%?? ANSWER: When we have an area we look to find the CLOSEST z-value associated with it. There is no .7000 but we […]