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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

6 Answers

How do i recover my corrupted MS Excel File ....???


Using proper locations to keep your office documents and making regular backups are great preventive measures against data loss. If you've lost a document or the whole bunch of them, do not despair. Modern data recovery tools can reliably detect, locate and restore documents even if they are stored on a badly damaged, corrupted, formatted or repartitioned hard drive or other storage media.

Use Hetman Office Recovery for recovering your corrupted MS Excel file: https://hetmanrecovery.com/recover_deleted_document/office-software.htm

Oct 17, 2016 | Computers & Internet

1 Answer

I am not able to open microsoft excel application. THE FIRST BOX THAT POPS UP: The application Microsoft Excel quit unexpectedly. Mac OS X and other applications are not affected. Click Relaunch to...


I would uninstall it and reinstall again. If that doesn't fix it, uninstall it and use Open Office instead. Far better, free open access and easier to use plus fully compatible with any microsoft stuff.

Mar 01, 2017 | Microsoft Excel Mac for Mac

1 Answer

290 W worth of fixtures on 300 W transformer. To obtain even current at all fixtures a wire loop is used. However Photocell caused Transformer to run hot and cause lights to come on and then off at 2 to...


Your photo eye is getting feedback from lights.
Shield photo eye from light so it doesn't click on-off

Open following link for more Power Pack information:
http://www.fixya.com/support/r8391011-power_pack_not_working

Add a comment for more free help.
Also take advantage of fixya expert assistance live.
For a price, expert works with you via e-mail while you work on timer or any do-it-yourself project.
Fixya is always less expensive than a service call.

Jan 26, 2011 | Intermatic Malibu 300W Power Pack...

2 Answers

Split AC system not cooling.


P-7 Error Code means: DC Voltage Problem in the outdoor unit.
Bad PFC & IPM Circuit Boards.
The Pridiom Group
201-266-8234

Jul 26, 2010 | AmcorAire UCHW-H24AF2 Split System Air...

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

What does Classifying Data mean


It means:
Data and information classification refers to the policies and procedures by which stored data is categorized so the information can be accessed, updated, protected, recovered and managed more efficiently in accordance with specific application requirements.
If you find it helpful,please vote my answer.God Bless

Oct 11, 2009 | Intel Motherboard

1 Answer

When i print a PDFdocument made as an excel sheet , i mean with chart ,all that's writed inside is not printed. On Printed sheet you can just see an empty schedule. thanks


Why not convert the PDF to Excel and then print the Excel Spreadsheet? Nearly everybody know how to use excel and print the contents.
You can try AnyBizSoft PDF to Excel Converter which can help you transfer the tables of PDF into Excel as the original format. All the charts and data will be preserved.
Have a try and hope it helps.

Jul 19, 2009 | HP Photosmart C5280 InkJet Printer

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)

3 Answers

Excel password removing


could you please supply us with the version of Excel you are using? it's under Help About Excel

Mar 04, 2008 | Excel (SS8SATAS5128400R)

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:

94 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18386 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...