[Blindmath] Doing calculations with Excel?

[Sarah L. Gales]

I don't even know what those are.  Grins.  I am lost when it comes to math. 
That's why I joined this list I figured I'd get some help while I make my 
way through the class.
Sarah
----- Original Message ----- 
From: "Ken Perry" <kperry at blinksoft.com>
To: "'Blind Math list for those interested in mathematics'" 
<blindmath at nfbnet.org>
Sent: Sunday, January 08, 2012 5:45 PM
Subject: Re: [Blindmath] Doing calculations with Excel?


>
> You could make a VBA macro to do things like the dot product and 
> multiplying
> matrixes if you wanted to dig into the VBA
>
> Ken
>
> -----Original Message-----
> From: blindmath-bounces at nfbnet.org [mailto:blindmath-bounces at nfbnet.org] 
> On
> Behalf Of Birkir R. Gunnarsson
> Sent: Sunday, January 08, 2012 3:19 PM
> To: Sarah L. Gales; Blind Math list for those interested in mathematics
> Subject: Re: [Blindmath] Doing calculations with Excel?
>
> Hi Sarah
>
> Keep in mind that Excel cannot do things such as multiplying to
> matrices for instance, so there are some basic things that Excel will
> not be too helpful with.
> However it does some statistical things very well, regressions,
> standard deviations etc. You can produce these by hand, which you
> probably will have to do, since using the built-in Excel functions are
> probably considered cheating, depends on what the class is.
> The thing I like about Excel is that most online hints, manuals and
> courses that have demo Excel spreadsheets are accessible, and you can
> work your way through Excel workbooks online. It takes time, but I did
> this for a few years very uccessfully as a risk analyst.
> Google some courses on Excel, Excel for beginners, regression with
> Excel, calculating standard deviation etc.
> Remember in Jaws ctrl-page up and page down will take you between work
> sheets in a work book.
> Pivot tables are not very accessible, but I doubt you'll use them.
> a formula in Excel always starts with an equals sign.
> a semi coln (:) is a range indicator.
> If you want to sum all values in cells a1 through a14 you type in the
> formula =sum(a1:a14) into any other cell.
> If you want to sum only absolute values of a cell, use a $ sign in front.
> =sum($a$1:$a$14).
> If you do not do this and then you insert a row at the top, the
> formula will automatically change to
> sum(a2:a15), if you do not use the $ sign to indcate aboslute position.
> Open Excel and play around with it, the sooner the better. It's a
> matterof comfort level.
> You should do fine. R is more powerful and fit for many statistics
> problems, but Excel can definitely do a lot of these things for you.
>
>
> On 1/8/12, Sarah L. Gales <imafarmgirl at verizon.net> wrote:
>> Hi everyone,
>>
>> I am interested in doing calculations with excel for the statistics class
> I
>> will be starting in a week and a half.  I realize it can't do everything,
>> but know it can do basic math and keep it organized in a way that my
>> Professor will be able to read if necessary.  The other students will be
>> using a calculator and writing down their answers.  The professor has
>> suggested I use excel.
>>
>> Does anyone know if there is a guide someplace of how to accomplish this?
> I
>> will be using excel 2010.  I have done math in excel but it has been 
>> about
>> ten years.  All I remember is that it had something to do with using
>> brackets or parentheses or something like that.  Can anyone help get me
>> started?  I don't want to end up failing this class.  Luckily I will have
> a
>> tutor.
>>
>> Sarah
>>
>>
>> __________ Information from ESET Smart Security, version of virus
> signature
>> database 6777 (20120108) __________
>>
>> The message was checked by ESET Smart Security.
>>
>> http://www.eset.com
>>
>>
>>
>>
>> _______________________________________________
>> Blindmath mailing list
>> Blindmath at nfbnet.org
>> http://nfbnet.org/mailman/listinfo/blindmath_nfbnet.org
>> To unsubscribe, change your list options or get your account info for
>> Blindmath:
>>
> http://nfbnet.org/mailman/options/blindmath_nfbnet.org/birkir.gunnarsson%40g
> mail.com
>>
>
> _______________________________________________
> Blindmath mailing list
> Blindmath at nfbnet.org
> http://nfbnet.org/mailman/listinfo/blindmath_nfbnet.org
> To unsubscribe, change your list options or get your account info for
> Blindmath:
> http://nfbnet.org/mailman/options/blindmath_nfbnet.org/kperry%40blinksoft.co
> m
>
>
> _______________________________________________
> Blindmath mailing list
> Blindmath at nfbnet.org
> http://nfbnet.org/mailman/listinfo/blindmath_nfbnet.org
> To unsubscribe, change your list options or get your account info for 
> Blindmath:
> http://nfbnet.org/mailman/options/blindmath_nfbnet.org/imafarmgirl%40verizon.net
>
> __________ Information from ESET Smart Security, version of virus 
> signature database 6777 (20120108) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
> 


__________ Information from ESET Smart Security, version of virus signature database 6777 (20120108) __________

The message was checked by ESET Smart Security.

http://www.eset.com