the main
about the project
Medicine news
To the authors
Licensed books on medicine
<< Ahead Next >>

Look, mommy, no Excel!

I am sure that you did not create the schedule for the first time, but I am ready to bet that you did it for the first time without a computer *. Of course, we started with a spreadsheet created on a computer, but did not use anything in our work. Why? The fact is that if we allow the machine to make decisions regarding the coordinate system - the critical part in the process of creating a meaningful schedule - then we lose the possibility of active vision.
* I built the whole book so that you can learn and perform each exercise with just a pen and paper. This was done quite deliberately, and on the last day of our work I will explain in detail why.
Of course, Excel and other spreadsheet programs have excellent built-in graphing features that allow you to quickly and accurately create and modify huge tables. However, I hope that you will see from this exercise: there is nothing difficult in plotting data on the chart field. Of course, the computer is needed to make the graph more beautiful or to make calculations, however, the most difficult thing in the process of creating an instructive picture is to find out what the data should tell us in principle and whether we use the correct coordinates for comparison. The trial and error process requires an active and intelligent look. No program is able to do this. It can only man.
Data to look at
bgcolor = white> 2.0
Thing Unit 1970 dollars 1990 dollars 2007 dollars Growth
Education at university (state) Year 688.00 1908.00 6185.00 9.0
University education (private) Year 2958.00 9340.00 23 712.00 8.0
Medicines (prescription) Month 11.37 33.59 68.26 6.0
New family house House 55 700.00 112,900.00 247 900.00 4.5
New car Car 6470.00 15 900.00 28 800.00 4.5
Petrol Gallon 0.67 1.16 2.80 4.2
Consumer Price Index (total) CPI-U 65.20 130.60 207.30 3.2
Movie ticket Ticket 2.34 4.22 6.88 2.9
Price of 1st class mailing Mark 0.15 0.25 0.42 2.8
Whole milk Gallon 1.05 2.27 3.76 2.5
Chicken eggs Dozen 0.82 1.01 1.68
Air flight (inside the country) Mile 7.49 10.83 12.71 1.7
Air Travel (International) Mile 8.49 13.43 12.98 1.5

Active vision transforms this ...

<< Ahead Next >>
= Go to tutorial content =

Look, mommy, no Excel!

  1. Creating Excel Charts
    Charts are a means of visual presentation of data and facilitate the implementation of comparisons, the definition of patterns and the identification of data trends. For example, instead of analyzing a few columns of numbers on a sheet, you can look at the chart, find out whether sales by quarters are falling or growing by quarters or how actual sales volumes correspond to the planned ones. Excel Chart is graphic
  2. Universal review competition "Genius in every family"
    Attention! Attention! Since 2006, the Creative Laboratory "Worlds Wizards" together with the Academy of Magic has been holding an international unprecedented culturological action - the Universal review-competition "GENIUS IN EACH FAMILY". Contestants take part voluntarily and get the title of Genius in the following categories: BUSINESS AND CAREER DRIVER-MAGICIAN WIZARD-UNIVERSAL EDUCATION
  3. Estimated categories of the competition
    Talented manager Superspecialist Client's dream Genius of management Best business strategist Negotiating and concluding contracts Support of the company Landscaper-cashderer Speed ​​master Pokatushek's motor scientist Traffic policeman Traffic policeman caster and congestion Orientation on the ground Figure skating Schumacher Friend of children Master of suggestions Mäugli is the master of cats Doctor
  5. Excel Chart Types
    Chart Types
  6. Principle No. 1. No Revolutions.
    You should not strive for quick results. As practice shows, they are not useful and persistent. At first, it is normal to drop a kilogram per week, then a pound. Under a categorical ban full starvation. The fact is that it is a huge stress for the body. After a person stops starving, the body will definitely get and go over everything that he has not received earlier.
  7. What will happen, if only to write a treatise, but no action is taken
    It is very likely that nothing will happen. You wrote a written, but did not begin to play, and the Universe can perceive it as a delayed action. That is, when the hour of X comes, then we will do everything that we have in mind. But it will not come, we will not do it. But it also happens that your intention to change something in your life is so clear and strong that what you want begins to be fulfilled right in the process of writing.
  8. There is no danger in losing weight.
    Many fear that fasting can lead to tuberculosis. It is believed that losing weight means susceptibility (vulnerability) of this "disease". But this fear is unfounded and is based on a false point of view. Thoughtfulness with tuberculosis is not the cause of the disease, but the result. Weight loss is important for recovery from "acute" disease, and nature provides that such a patient
  9. Breaking a diagram with a data range.
    Above (when telling about axis settings in the “Axis Format” window) we already mentioned the “Contact source” option on the “Number” tab of this window. Here it is necessary to say one more thing: if you disconnect all links with the source in the diagram, you can get a diagram that has no links to the worksheet data, but exists as if by itself (“dead diagram”), separately. Such a diagram is not afraid
  10. Notes
    1. See note 1 for the third lecture. 2. Now we know a lot more about the conditions that affect the course of children's mourning. See notes 4 and 5 for the third lecture. 3. See Glyk, Weiss, and Parkes
  11. Chart structure (chart elements)
    The story about working with diagrams will begin by returning to the beginning of the previous section and recalling the structure of the data representation in the diagram. So, the data representation on the chart has its own structure. It consists of a data marker, main lines, category names, chart series names, and a legend. And what is the structure of the diagram itself? A whole variety of types of Excel charts has one and
  12. Chart Editing
    In an Excel chart, the appearance and thickness of any line, its color and style, and the style of the markers change. In addition, you can freely change the font, style, height of the character, text and other parameters of any text element of the diagram - from headings to legend elements and axis labels. The ranges of data on which the chart is built can be changed (add or delete by the user by any
  13. P.S
    The advocated approach was adopted with notable success by Mary Salter Ainsworth, many of whose publications are listed in the references on pages 161-162, as well as by Nicholas Blurton Johnson (1972). For a modern description of ethological concepts and discoveries regarding a person, see Hinde (1974). Notes 1. In the original version, I used the common
Medical portal "MedguideBook" © 2014-2016