Discussion about math, puzzles, games and fun. Useful symbols: ÷ × ½ √ ∞ ≠ ≤ ≥ ≈ ⇒ ± ∈ Δ θ ∴ ∑ ∫ • π ƒ ¹ ² ³ °
 

You are not logged in. #1 20120219 21:06:53
anyone good with doing math on excel?iv been trying to get this problem on excel but so far nothing anyone think they can help? #2 20120219 23:35:03
Re: anyone good with doing math on excel?Hi alexman617; In mathematics, you don't understand things. You just get used to them. I have the result, but I do not yet know how to get it. All physicists, and a good many quite respectable mathematicians are contemptuous about proof. #3 20120220 02:08:37
Re: anyone good with doing math on excel?Hi alexman617, "The good news about computers is that they do what you tell them to do. The bad news is that they do what you tell them to do."  Ted Nelson #4 20120220 09:44:03
Re: anyone good with doing math on excel?hey thanks guys helps me alot, i have 2 more i need help with, if you want to help it would be appreciated thanks #5 20120220 09:45:14
Re: anyone good with doing math on excel?Please post them. In mathematics, you don't understand things. You just get used to them. I have the result, but I do not yet know how to get it. All physicists, and a good many quite respectable mathematicians are contemptuous about proof. #6 20120220 10:30:38
Re: anyone good with doing math on excel?heres the second one #7 20120220 10:38:20
Re: anyone good with doing math on excel?Hi alexman617; In mathematics, you don't understand things. You just get used to them. I have the result, but I do not yet know how to get it. All physicists, and a good many quite respectable mathematicians are contemptuous about proof. #8 20120220 10:39:00
Re: anyone good with doing math on excel?thanks for the help im glad theres people out there that are willing to help #9 20120220 13:02:32
Re: anyone good with doing math on excel?Hi alexman617; The average value of this game is 1364349 / 32000 = 42.63590625. The above answer is the exact answer given by expanding the generating function that represents this problem. It will do you little good because it appears they want you to write an excel program to do this. Programming is a very personal thing and you should do it on your own. Anyways, I do not program in excel but the exact answer can at least point you in the right direction. In mathematics, you don't understand things. You just get used to them. I have the result, but I do not yet know how to get it. All physicists, and a good many quite respectable mathematicians are contemptuous about proof. #10 20120426 05:20:31
Re: anyone good with doing math on excel?Hi HambrickWeldon;
As far as I know I am the only person in the galaxy to have figured it out using mathematics. If you have another solution then I would like to see it. In mathematics, you don't understand things. You just get used to them. I have the result, but I do not yet know how to get it. All physicists, and a good many quite respectable mathematicians are contemptuous about proof. #11 20120426 17:24:48
Re: anyone good with doing math on excel?That is what I would like to see your math. In mathematics, you don't understand things. You just get used to them. I have the result, but I do not yet know how to get it. All physicists, and a good many quite respectable mathematicians are contemptuous about proof. #12 20120426 17:39:18
Re: anyone good with doing math on excel?hi HambrickWeldon You cannot teach a man anything; you can only help him find it within himself..........Galileo Galilei #13 20120427 00:45:50
Re: anyone good with doing math on excel?I am not sure how a forum works sorry, I am a mom of teenagers and just returned to school. So its been a looong time since I have done math besides adding things up at the grocery store. Can I post the math problems in this topic? I am going to and see if I get any feedback? I need help with a problem that has fractions in it but I don't know how to put it on this post, can someone help? #14 20120427 01:16:06
Re: anyone good with doing math on excel?EDIT: Seeing Bob's nice formulas gave me this idea. See image: (a) RANDBETWEEN(x,y) returns a random number between the specified numbers. My Excel v2007 has that function, but I don't know if other versions have it. (b) Enabling iterations in Excel can keep the spreadsheet entries to a minimum, and this is demonstrated in the little program (see below) that runs from just a few lines. I'd initially entered the formulas into column A, but changed to column B in order to show and explain them better (see image). To run the program in Excel v2007: 1. Add the 'Calculation Options' button to the Ribbon: Office Button/Excel Options/Customise/All Commands/Calculation Options/Add/OK. That button enables quick selection of manual or automatic calculation mode. Click the button and select 'Manual'. 2. Enable iterations: Office Button/Excel Options/Formulas/Calculation options. Tick the 'Enable iterative calculation' box and in the 'Maximum Iterations' box enter 10000. I left 'Maximum Change' at the default 0.001. Click OK. 3. Enter the formulas from my spreadsheet image. 4. Press F9 (or click the 'Calculation Options' button and select 'Automatic') to start the ball rolling (dice, actually)...and sit back and watch the spinning tumblers in column B. 5. To reset column B results, first click the 'Calculation Options' button and select 'Manual'. Then in each cell to be reset (B2:B5), left doubleclick it and press Enter. 6. Press F9 to start the calcs again. Each subsequent press increases the number of games by 10000. 7. You can check the validity of the program by setting iterations to 1 and then pressing F9 to monitor the column B results. Calcs can be set to either manual or automatic for this. 8. If you want more automated results per F9 press, increase iterations (max 32767 in Excel v2007). 9. You may want to reenable auto calcs for your other programs...which you can do from the new Ribbon button that was set as per note 1. When leaving this program you should probably also disable iterations by removing the tick you put in the box (see note 2). 10. The "B2*0+" in B2 is the trigger that sets off the iterations to automate the calculations. Here's a link to my spreadsheet in action: Animated results Last edited by phrontister (20130430 13:34:53) "The good news about computers is that they do what you tell them to do. The bad news is that they do what you tell them to do."  Ted Nelson #15 20120427 02:55:17
Re: anyone good with doing math on excel?Hi Jenniferm; In mathematics, you don't understand things. You just get used to them. I have the result, but I do not yet know how to get it. All physicists, and a good many quite respectable mathematicians are contemptuous about proof. #16 20120427 04:24:29
Re: anyone good with doing math on excel?hi HambrickWeldon, You cannot teach a man anything; you can only help him find it within himself..........Galileo Galilei #17 20120427 11:10:42
Re: anyone good with doing math on excel?Hey! HambrickWeldon's posts have vanished!!(??) Below is an image for my solution. Again, inspired by Bob's method. Same idea re iterations as for the dice puzzle (see my post #14). The "B2*0+" in B2 is the trigger that sets off the iterations to automate the calculations. You can check the validity of the program by setting iterations to 1 and then pressing F9 to monitor the column B results. Calcs can be set to either manual or automatic for this. Here's a link to my spreadsheet in action: Animated results Last edited by phrontister (20130430 13:35:42) "The good news about computers is that they do what you tell them to do. The bad news is that they do what you tell them to do."  Ted Nelson #18 20120427 11:17:31
Re: anyone good with doing math on excel?He deleted his posts. The limit operator is just an excuse for doing something you know you can't. “It's the subject that nobody knows anything about that we can all talk about!” ― Richard Feynman “Taking a new step, uttering a new word, is what people fear most.” ― Fyodor Dostoyevsky, Crime and Punishment #19 20120427 11:51:56
Re: anyone good with doing math on excel?Does anyone have the wording for HambrickWeldon's coinflip puzzle, so that we can include it here as reference for anyone interested in this? Last edited by phrontister (20120428 01:52:37) "The good news about computers is that they do what you tell them to do. The bad news is that they do what you tell them to do."  Ted Nelson #20 20120427 12:01:52
Re: anyone good with doing math on excel?HambrickWeldon has deleted his posts! In mathematics, you don't understand things. You just get used to them. I have the result, but I do not yet know how to get it. All physicists, and a good many quite respectable mathematicians are contemptuous about proof. #21 20120428 02:15:35
Re: anyone good with doing math on excel?Hi Bobby, "The good news about computers is that they do what you tell them to do. The bad news is that they do what you tell them to do."  Ted Nelson #23 20120428 02:25:14
Re: anyone good with doing math on excel?Hi phrontister; In mathematics, you don't understand things. You just get used to them. I have the result, but I do not yet know how to get it. All physicists, and a good many quite respectable mathematicians are contemptuous about proof. #24 20120428 03:49:37
Re: anyone good with doing math on excel?Hi Raito, "The good news about computers is that they do what you tell them to do. The bad news is that they do what you tell them to do."  Ted Nelson 