Computer problems,Computer help
*AX SOFT>>>Software

Excel!Statistics! Help me!?


Alright, I have been provided the prime rate, and the car sales trends for, jan 94 to Dec 98.

Now what needs to be done is determine the mean, median, variance, standard deviation. Then determine the Covariance, Least squares (regression) equation, Correlation coefficient, then graph the least squares line over the scattergram.

Also if possible could someone help me figure out how i would find out the annual car sales for 2008 should be based on this information. The interest rate will average 4.75% over the course of the year.

Any help would be greatly appreciated! Thanks!

The easiest thing for you to do is move your cursor to the cell where you want the formula, then click on the "fx" icon in the Edit window. Follow your nose through all the formulas. All those you've listed are outlined (except for the least squares regression equation, but that may be called something different).
The scattergram is a graph, and it's just that.... a scattered mess. Sounds like that is to be charted based on one of your calculations.

excel cant do that and whatever ur saying i cant understand or maybe its cause i didnt read ur question

Tags
  General - Computers & Internet   Software   Security   Programming & Design   Facebook
Related information
  • How do I install two Operating systems on one drive?

    You should not use it as a server,,,,,,when its not set as a server,,,,,,,,,,a server should run eec memory,, unless your motherboard can run both,,,,,, If you have the hard drive space to sp...

  • Why wont iTunes open on my computer anymore?

    I actually had the same problem with mozilla myself. i had to use a different browser for a while. But to answer your question, i need to ask you one. How up to date is your anti-virus? because thi...

  • How do i download adobe flash for free on my PSP?

    Check here - ...

  • How can you save Microsoft 2007 document under 2000 or 2003?

    Right. Hopefully this works. File > Save As.. When the box comes up in which you select the location and name the file. Click on the bit where you get to name the file. Now, underneath ...

  • Which Adobe Photoshop program is better for me?

    If you are going to buy Photoshop, I suggest getting the newest version (CS3) just because it's the newest and best. It is expensive however. It's made for professionals in mind, but anyb...

  • Why does tuneSE.com load a blank page after i click download?

    Try right clicking on the link and choose 'Save Target As', this will download the file and not open a blank page. Good luck!

    ...
  • Does any one know where to download sub7?

    Sub7 was around when 98 was the flavour, however I would be suprised if it actually worked on most pc's as they either run XP or vista or linux. Also with the advent of routers and general ...

  • Any good tutorials for Microsoft Word 2007?

    There are a few books for non tech savvy people about Office 2007. Try the link below for Office 2007 for dummies. Good luck!

    ...
  •  

    Categories--Copyright/IP Policy--Contact Webmaster