Hello,
I have installed the Analysis ToolPak successfully (and have used the Data
Analysis tools many times before), but sometimes the Data Analysis option
simply fails to appear in the menu. What could be causing this?
Thanks,
Eric
Hello friends!
I want to know about data analysis through application of Excel. Please guide me if anybody knows about this.
Awaiting for your earliest reply.
Thanking you.
hello
i have collected feedback regarding the usage of timesheet as a part of my MBA project.
the feedback is in MS EXCEL.
I would like to do some data analysis and put the data in form of charts.
pie charts are too elementary.
my professor insists in statistical tools which i dnt have.
the questions are given and the employees were asked to give the opinion on based of 5 point scale.
Strongly Disagree 1
Disagree 2
Undecided 3
Agree 4
Strongly Agree 5
what can i do in excel? I have no clue about it...
pls help me out...
I am new to excel and need to install the "data analysis" add-ins found under
"Tools" for an assignment for a statistics class. I do not have the original
CD used to install Office 2003 and hope there is a way to access and install
these add-ins from the web.
I have a spreadsheet that shows a date, because of shipping I need to enter a
date and then calculate three months back and enter that date, For example
Cell A1 March, 2004 and I have to enter into cell B1 January 2004, how do I
get Excel to do this automatically.
Please can anyone help me answer any of these questions:
How would you add the contents of the cells from A1 to A10. Give 2 ways
to do this. (hint: Look up "Examples of common formulas" in Excel
help
How do you format a cell to have dollar signs next to the numbers?
How do you add the contents of cells A1 through A10 on sheet 1 and make
the answer show up on sheet 2?
How do you rename a sheet?
Can I delete the sheets that I don't need? If so how?
How do I freeze rows or columns of the sheet so that they don't'
move when you scroll up or down? Example: My name is in Column A, when
I scroll right my mane stays on the screen and column B moves behind A
How do you add up all the contents of column D and make the answer show
up in column C?
Thanks in advance!
abi
I am looking to run certain statistics in Excel and I was wondering if this was possible:
I want to calculate a certain number of people in a category on a spreadsheet by age and race and I wanted to know if it could be done in Excel. We do not have a specific program here to calculate statistics like SPSS.
I have a spreadsheet of patients with their information such as age, telephone number, Date of birth, race, location of cancer screen, date of cancer screen, and results of cancer screenings.
I have a lot of information and I was interested to know if I could select only certain columns (age, race, cancer result) to run the statistics. I need to make charts containing the number of people who screened for cancer and out of those people, how many were which race and how many were in each age group.
If this kind of data is possible to obtain in Excel, how do I go about doing that?
Thank you!!
Hi,
This is my first time using Excel 2003 VBA. I have picked up a VBA book, but am having trouble applying it to my needs.
I am working with a spreadsheet that is organized in such a way that it makes sorting difficult (the data is imported from another program), so I want to use VBA to extract the data.
1. I want to build a master list from the data. To do this, I propose a loop that will go down and collect a list of items. I also want to count the number of items in the master list.
This is what I am trying to count the items, but I get an error at the If itemtype:
For rowcounter = 3 To 500
itemtype = Cells(rowcounter, 4).Value
If itemtype = 1 Then itemcount = itemcount + 1
End If
Next rowcounter
What is the correct syntax?
2. How do I then create a loop that will count sub-items until it hits a blank cell?
I am thinking of this command: ActiveCell.Offset(1, 3)
But how do I use this so it loops until it hits a blank cell?
3. How do I test for leading characters, then ignore the cell if they are present? I want to see if the cell begins with "Total", and if does, then ignore it?
Are there any other books or on-line resources that have lots of sample code? I have searched, but not found anything applicable. I have found the code samples to be limited.
Thanks
