Question about Microsoft Excel for PC

1 Answer

How to transform interval data to categorical using mean split

How to transform the interval data to catogorical data in excel mean split

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 45 Answers

Use vlookup or hlookup

Posted on Nov 17, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

Excel Corruption files


Without seeing the file, it is difficult to diagnose what is going on, but I will offer some ideas.

What version of Excel are you using? Are you using Excel 2003? Was the file you are trying to open created in Excel 2007 or Excel 2010. If so, it might be using the new format and therefore will not open in Excel 2003 and older.

It is possible the Excel file is data that was imported from a source in which Excel cannot import. Does the Excel spreadsheet contain any imported data?
Try to use: XLSX Viewer Tool here : http://www.xlsx.viewertool.com/
Those are the most likely causes of the corrupt data. Is every file you open in Excel corrupt, or just this one workbook? If it is just this one workbook, then, yes, it sounds like it is corrupted. If every file you open with Excel is corrupt, then your version of Excel could be corrupt, but that is unlikely.

Jul 10, 2015 | Microsoft Excel for PC

1 Answer

How to break into 2 columns A4 lanscape size paper in ms-excel.


when you open a new page in word or excell, in the menu bar across the top there will be examples of page set up
click on the one you want and it should give what you want

Jun 12, 2015 | Microsoft Office Excel 2007

2 Answers

Excel Error Message.What can I do to stop this error?


A corrupt excel spreadsheet can be repaired by using Open and Repair technique. It is a built-in repair function that opens a corrupt excel file forcefully.
*OpenMS Excel >pressCtrl+O >locate corrupt excel spreadsheet and select it.
*Click on the arrow shown besideOpenbutton>selectOpen and Repair.
It will take just a few seconds to be completed and selected file will be opened, if possible.

Or if this doesn't work, one may take help of a third-party

For example Excel Fix Toolbox
https://www.fixtoolbox.com/excelfix.html

Apr 24, 2015 | Microsoft Office Excel 2007

1 Answer

Not Enough Memory to run Microsoft Office Excel. Please close other Applications and try again..


Excel running on a 32 bit PC and using a 32 bit operating system can only address 2 Gb of RAM. If your machine has a 64 bit processor (these were being shipped over 5 years ago) it will be possible to install a 64 bit operating system such as Windows XP 64 bit or Windows 7 64 bit. It has been claimed that an Excel 2010 spreadsheet, running on a 64 bit machine and using Windows 7 64 bit, was able to load and use a database with 100 million records.

If you are unable to do this then I suggest that you examine what your machine is running at the same time as your spreadsheet and if any part of the spreadsheet can be off-loaded. By the latter I mean can any of it transferred to another Excel file?

Are you using any links on your spreadsheet, if so can the links be converted into data, e.g. a link to a lookuptable could be converted to data (copy, paste-special, value) and this remove a significant amount of processing load.

Oct 18, 2010 | Microsoft Excel for PC

1 Answer

Question no. 2 For the 50 observation given below. Prepare Frequency Distribution for the the class interval is 10 (lower limit starting is 0) and upper limit is 80. Also plot in graphing. 64 62 52 50 70...


64 62 52 50 70 60 55 20 25 48 35 55 55 47 64 42 36 50 30 53 51 63 58 50 60 54 33 48 40 76 61 46 65 65 15 45 58 40 64 18 33 40 64 18 33 40 48 9 38 41

Highest value observed: 76
Lowest Value: 9
Standard deviation from the ungrouped data: 15.25
Frequency:
Mean: 46.94
Standard deviation from grouped data: 15.40

Oct 23, 2009 | Microsoft Excel for PC

1 Answer

I have a question; How do I seperate address written in one column into 4 column as line1 line 2 citi pincode


Assuming 1) you're using Excel and 2) the addresses are written:

1234 Main St., Anytown, CA 90210

You can use "Text to Columns" feature (selected "Delimited" and check the box next to "comma"). This will split the data into 3 columns (address | city | state and zip). Then run the "Text to Columns" again on the "state and zip" column and use "Fixed width" to separate the state from the zip.

If the assumptions I used are incorrect, clarify and we'll try again.

Jan 06, 2009 | Business & Productivity Software

1 Answer

Input data


If you want to transfer your data into SAS, SPSS, or some other program, follow these guidelines:
The cells in Row 1 should contain the column's eventual data set name. Each name should be a relatively short and unique acronym that clearly identifies the data. It should begin with a letter and contain only letters, numbers, or an underscore ( _ ) where spaces would naturally fall. Avoid using special characters such as $, &, @, in variable names. Since each row represents the values from one subject, the first column(s) should contain one or more variables that give each subject a unique identifier. They become especially important if you need to merge two or more data files.
In Excel, data formats are defined for a range of cells rather than for a complete column. For this reason it is important that each entire column, including cells with missing or uncollected data, have one, and only one, format. Actually, you do not need to format the entire column, only the portion you will eventually use. Highlight that portion and select the appropriate format from the Format/Cells option. Do not select formats that will enter commas, dollar signs, or other visual enhancements. Numeric, text, and date formats (e.g. mm/dd/yy is often a good choice) are probably the only formats you'll ever need.
The "Split" option (under the "Window" pull-down menu) keeps the row of variable names and the columns of identifiers in view, whatever range of cells in the worksheet you may need to review. First place the cursor at the most extreme upper left-hand corner where data entry begins (e.g., the intersection of Row 2 and the column in the upper left-hand corner where data appear) and then select "Split" from this menu. For any row or column of the worksheet you move to, you'll know exactly which variables you are observing (column names) and their associated ID values (rows).
For versions of Excel later than 4.0, one file can contain multiple worksheets. By default, the tabs at the bottom of these sheets are supplied names ("sheet1," "sheet2," etc.). You can change these names by clicking this space with your mouse and entering a new name. Use the same conventions for first-row variable names: use a short acronym of the page contents that begins with a letter, use only letters or numbers, and enter the underscore ( _ ) where a space naturally falls.

Jan 05, 2009 | Sage Instant Accounts 8.0 (013604ug)

5 Answers

Forgot password to open Excel sheet


If you mean that you can open the Workbook and read the Worksheet - then all you have to do is select all and paste it to another Worksheet. This will allow for changes of formulas etc.

If you mean the whole Workbook - then I dunno.

In future, either use the same password for everything (easy to remember) or Protect the work with nothing entered into the password field (leave this blank). This last will protect the work from people who try to guess your password, but will be easy for you to remember - eg every password is left blank.

If you must use unique passwords, then keep a record of them somewhere other than on your computer.

Sorry I can't help with the "Workbook" solution - but somebody else out ther may be able to do so.

Apr 25, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Microsoft excel(data analysing)


Microsoft Excel is an application used for building spreadsheets. It has many built in calculation and graphics tools. Some people use it to track expenses while other use it to graph numbers for charting process. As far as data analyzing it all depends on the data. Whether is sales figures or budget information. It all can be done inside of excel using it built in formulas and functions.

Sep 22, 2007 | Microsoft Office Standard for PC

3 Answers

Changing data in table to rows


In what program? In Excel, you could simply select D,E,F and drag under A,B,C. Same with G

Aug 07, 2007 | Microsoft Office 2003 Basic Edition...

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

93 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18297 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...