hello - I am not sure I’ve used the right tags but cannot expand the drop down enough to read properly, nor can I type in my course. I am having a hard time utilizing this site and I am stuck on the graded lab bakery study:
the cell C15 is referenced but that cell represents a month. i can find the answer to total amount of purchases for hour 11 but why are we involving C15?
“1. In cell C15, find the total amount of purchases that happened during the hour 11. (Use sumif rather than countif.)”
the next question references line 15 too but it doesn’t make any sense to me even with a hint.
“2. Enter a similar formula in cells D15:K15 for the rest of the opening hours.
HINT: Using a combination of relative and absolute cell references (with the $), you can write just one formula, then use the fill handle to drag it to the other cells.”
Hi Elizabeth. Can you post a screenshot of what you mean by “represents a month”? I checked the blank copy and cell C15 is just a blank cell right below the heading “11”. That aligns with the question. Same goes for the next question.
if your rows and columns are exchanged, that would make more sense as to why i’m stuck. did i miss something i don’t see where there was instructions to change it and this was how the file opened for me.
and that might help explain the circular ref error in question 2, any recommendations of what my next steps should be?
thank you very much!
Hi. The C15 mentioned in the instructions pertains to the cell C15 on the same sheet (i.e. 1 - Time trends). It indicates where you will place the formula. You’re not supposed to edit C15 in the Data sheet. You’re just going to use the Data sheet to compute the values, but the formula would still be placed in C15 of 1 - Time trends. You can review the demos in the lectures to see how Sean does this (i.e. putting ranges from other sheets to a formula placed in a another sheet). Hope this helps.
is there a place for this course? i can’t find anything on this site for community for data analytics foundations (i’m still in course 1 
)
. i’m continuing to get hung up and slowed down. this time for the capstone project. it’s not really working for me very smoothly. my charts i’ve already created get messed up because i’m adding new columns to satisfy the chart requests and everything is kind of a mess.
scatter plots have slowed me down a ton bc there isn’t an easy way to change the source for the y axis (the way there is to change the x)
Hi elizabeth_joyce,
You can change the sources for the y axis by selecting or removing the series. You can also add series which then become sources for the y axis.
I have tried that but specifically, the question asks:
5. Use these new columns to create a scatter plot for Avg Monthly Long Distance Charges vs. Average Monthly Revenue. You should have one color per Customer Status value. What does this plot tell you? Are there any outliers?
its putting the customer status value on the y, i need it to be monthly avg prices but don’t see how to force that onto y rather than it using it like another series.
You should have created the columns ‘Churned’ and ‘Stayed’. If you select these together with Avg Long Distance Charges, you can then insert a chart. This you should change to a scatter plot. Then, the x-axis should be changed into avg monthly long distance charges. Next adjust your series to select ‘Churned’ and ‘Stayed’ and remove Avg long Distance Charges. If this does not give you the correct scatter plot, there may be something wrong with your formulas and you may wish to check those carefully. Don’t be afraid to delete a chart and try again. Good luck!
