Microsoft Office Q&A: Ask anything (Word, Excel, PowerPoint, etc.)

www.prezi.com

You just build them right there on their website.
They have absolutely nothing to do with Microsoft Office.

Eric Ross59 said:Hey, I could use some help with this formula.



Can someone explain how to actually run this formula in Excel?

Look, I'm definitely no math whiz, but I used the STDEV formula to figure out that S value. I checked both the version in Microsoft Office and the one from my old intro to stats textbook.
I get that S15 is just the number of repetitions, but you might want to wait for someone smarter to weigh in on what to do with it.
Hope that helps.

Click here for the hidden image. 🤷

Betty Hayes10 said:www.prezi.com

You just build them right there on their website.
They don't even interact with Microsoft Office.

That’s the one!

Thanks a ton!

Betty Hayes10 said:I'm working on a script right now. Just yesterday and today, I've been hitting Ctrl + S to save my progress, just like I always do.
Microsoft Office crashed on me three separate times right when I hit that shortcut. I actually had to retype everything.
Does anyone else deal with this when they try to save a Microsoft Office file using a keyboard shortcut?

If you want a lifesaver, look up "save-reminder" online. It’s a plugin for Microsoft Office that creates a backup every few minutes to a different location.
After I lost a document once—or maybe twice—because I accidentally clicked "no" instead of "yes" while rushing to close the program, I realized how vital this is. It gives you a secondary version of your work tucked away somewhere else... a true safety net.

Melissa Martin32 said:So, I'm assuming that S15 represents the number of repetitions?

Forget about calculating sums, power, or any of that other clutter; all you really need are the test results and the STDEV function.I don't see a link here. Did you forget to attach it?

Taylor Campbell4 said:You know what would actually be useful? Go look up "save-reminder" online. It’s a plugin for Microsoft Office that triggers a backup to a separate location every few minutes. Why wouldn't you use something like that?
After losing my work once or twice because I rushed through closing a window and accidentally hit "No" when the prompt asked to save—which, honestly, who hasn't done?—I can say this is a lifesaver. It’s an excellent way to ensure you actually have a backup version of your file sitting somewhere else, even if you mess up the original.

Thanks!

First off, my bad to Dobrota—I totally messed up the Standard Deviation formulas earlier. I botched the N-1 part by forgetting to subtract 1, which you can actually see in cells B14 and B35 in the screenshot. This time, I’m sticking to a Microsoft example and that other one Betty Hayes10 shared with us.

Everything's fixed now, and here are the actual formulas:

Betty Hayes10 said:You don't need SUM or POWER or whatever; just grab the test results and use the STDEV function.LINK

Betty Hayes10, what you posted is way off. If you use the STDEV formula, you should be getting 4.47. And if you follow the step-by-step method like I did, the result has to match.

Just a heads up, we square things during the calculation specifically to get rid of those negative signs in the deviations.

I'm sure you get why I went through the whole step-by-step process—just trying to make sure I actually learned how this works. 😉

Lozimka said:Did you double-check your math on paper instead of just relying on Excel?

Check out this YouTube link. It breaks down how to calculate deviation super simply, so you can see who’s actually right here.

Definitely let me know if you still think I'm off base. I tested these Formula setups against four different examples, including two straight from a stats textbook.

So, how did you run your deviation numbers?

Sorry to crash this discussion, but maybe I can shed some light on this. As far as my understanding of statistics and testing goes, using an Excel Formula like STDEV works just fine if you're dealing with ungrouped values. However, if you're working with grouped data, you have to approach the solution step-by-step, exactly like the method someone else described in that image they posted.

Dana Diaz8 said:Sorry to jump into this thread, but maybe I can clear things up. From what I know about stats and testing, you can just use an Excel Formula STDEV if you're dealing with ungrouped data. But if the values are grouped, you have to work through it step-by-step, kind of like how someone else laid it out in their screenshot.

Don't even worry about apologizing. Honestly, the whole point is that we all learn something, right? Since the result ends up being the exact same whether I use STDEV or do the manual math, I’m actually more confused now than when I was trying to find the error in my last screenshot.

Betty Hayes10 and I were the ones who posted the images, so I'm not really sure which one you're talking about.

Melissa Martin32 said:Here’s a YouTube link that breaks down how to calculate standard deviation in plain English, so you can see for yourself who actually knows what they're talking about.

By all means, set me straight if you still think I've got this wrong, though I highly doubt it. I've already run these formulas against four different sets of data, including two straight out of an American statistics textbook.

So, how exactly did you come up with your version of the deviation?

Test results:

x1 = 5
x2 = 4
x3 = 8
mean = 5.7

i = 1, 2, 3
n = 3

Result: 2.08

Plug it into the Formula, do the math, and then double-check it in Excel.

Betty Hayes10 said:Test data:

x1 = 5
x2 = 4
x3 = 8

i = 1, 2, 3
n = 3

Result: 2.08

Just plug it into the Formula and you're good. Double-check everything in Excel.

Here’s the Formula I'm using:



Can you drop the actual Formula here or at least show how you ran the numbers in Excel?

In Excel, you just need the STDEV.

Betty Hayes10 said:

Just use STDEV in Excel.

So, in that first screenshot, you just listed numbers from 1 to 15, which is why I used Count. 😁

We ended up with the same result, we just use Excel a little differently.

I didn't actually include those numbers in my calculation. They're just sitting there to show you what "i" represents.

There's absolutely no reason to waste your time calculating columns b and c. Just let STDEV handle everything.

Just a quick reminder that I already linked the Excel Formula for STDEV back on the last page.
As for columns B and C, I used them just like in the examples I posted here and over here. I could have skipped them, sure. But then I wouldn't have known exactly which part was actually part of the formula. It's kind of like how you use your "i."

I get that you could have answered the question using just the STDEV itself. Honestly, I think we finally settled this formula once and for all. 😍

We sure are. 😉

Melissa Martin32 said:First off, I really want to apologize to Eric Ross59 because I actually used the wrong Formula for calculating standard deviation earlier. It turns out I made a little slip-up with the N-1 calculation since I forgot to subtract 1, which you can actually see clearly in cells B14 and B35 in that screenshot. This time around, I’m sticking to an example from Microsoft Office along with that other one Betty Hayes10 shared with us.

Everything is all fixed up now, and the Formulas should look like this:

I really appreciate the help from @Melissa Martin32 and @Betty Hayes10 for all their hard work here. 🙂

You know, while I was already somewhat familiar with the whole "step-by-step" manual method, I couldn't help but wonder if there wasn't a more streamlined, efficient way to get to the same result—and thank goodness, it turns out there absolutely is! 🙂

It's such a relief to see that using STDEV gives me the exact same result as doing it all manually, which was really the most important thing for me to confirm. 🙂

Thanks again, everyone! 🙂

I think I might need some help figuring out how to insert page numbers in Word. Basically, I’m trying to get the numbering to actually start on the second page instead of the first—if you know what I mean. Does anyone know the best way to set that up?

There’s a mountain of replies to this question, and honestly, if you want the real meat of it, you should just head over to page 83 of this
forum.

I could use a little hand with Excel. I’m trying to figure out which Formula to use for a specific setup... For example, if I select cells C5, B10, C13, and B21, how can I type a name into cell D8 and have that exact name automatically pop up in all those previously selected cells?