Excel Statistics 11: Descriptive & Inferential Statistics
Loading...
24,292
Uploader Comments (ExcelIsFun)
see all
Video Responses
This video is a response to Excel Statistics 10: Data & Scales/Levels of Measurement
Loading...
Great videos. How did you get it to automatically fill in "Organic Sales" after "2006" at 4:13?
fbuccella 7 months ago
The best way is to; 1) select chart title and make sure that outer edge is a solid line (not dashed), 2) Click cursor in formula bar, 3) Type words, 4) Hit Enter
ExcelIsFun 7 months ago
@ExcelIsFun In the video it looks like you didn't type them though; they instantly appear. I thought you had somehow pulled the text from a cell but now I'm thinking it's just the video skipping a bit.
fbuccella 7 months ago
No, if you select Title (no dashed lines), Type and hit Enter, the title will appear. Try it and you will see.
ExcelIsFun 7 months ago
The graph at 2:16 is actually panel data, that is, observations of many variables in successive times, it is not time series which only describes one variable in successive times.
Other than that, video is cool.
Haridemos 10 months ago
Thank you for that correction! I have added a annotation for cllarification.
ExcelIsFun 10 months ago