TutorMe homepage
Subjects
PRICING
COURSES
Start Free Trial
Sara P.
Program Coordinator at the University of Arizona College of Medicine-Phoenix
Tutor Satisfaction Guarantee
Microsoft Excel
TutorMe
Question:

It is the end of the year and your boss has just given you an excel sheet filled with thousands of client payment data for the year. The first two columns have the client's first and last name. The third column is how much the client payed this past year. The data values are mixed between numbers and monetary values (\$). Your boss wants you to filter through the data and make a heat map of the highest paying clients, the clients who paid moderately, and the clients who payed the least. How would you accomplish this task?

Sara P.

The first thing that should be completed is making the data into the same currency. The data in column three (column C in excel) should all be listed as monetary values, meaning they are represented with dollar signs. To change the value, select the column by double clicking on column C. With the column selected, under the home tab, look for the section labeled "Numbers." In this section, you will see a dollar sign, percentage sign, and a decimal sign. By clicking on the dollar sign, all values in column C will be changed into monetary values. Now that the data being analyzed is the same unit, the data can now be used to create the heat map. With column C still selected, under the home tab, select the tool labeled "Conditional Formatting." Scroll down and click on the "New Rule" selection. 6 options will pop up but the option best suited for heat maps will be the first option labeled " Format all cells based on their values." With this selected, scroll down to the option labeled "Format Style." Since the job was to find who paid the highest, lowest, and in-between, the format style should be a 3-color scale instead of a 2-color scale. From there, the lowest values will be shaded in red, the moderate values will be shaded in yellow, and the highest values will be shaded in green. Where the name heat map comes from is that values in between red and yellow will have an orange shade associated with them while values in between yellow and green values will have a greenish-yellow shade associated with them. A heat map also makes it easy to see which values are the lowest and which are the highest without sorting the values highest to lowest.

Chemistry
TutorMe
Question:

What is the difference between Sodium (Na) and Sodium+ (Na+)? What is the reason for the difference?

Sara P.

Sodium is the 11th element on the periodic table. That means that sodium has 11 protons and 11 electrons. The difference between sodium and sodium+ is that sodium+ has one less electron than sodium. Sodium+ still has the same amount of protons as sodium. However, sodium+ would be considered an ion because there is an overall charge. Sodium has a bet overall charge of zero because 11 protons (positive charge) and 11 electrons (negative charge) cancel each other out. Sodium+ has 11 protons but only 10 electrons, which means there is an overall +1 charge due to more protons in the sodium+ ion.

Psychology
TutorMe
Question:

According to Sigmund Freud, the human psyche is divided into three parts; the Id, the Ego, and the Super Ego. Of the three divisions, which is labeled as being primitive and selfish in nature?

Sara P.

The correct answer is the Id. The Id is the primitive component of an individual's personality. The Id is completely unconscious and the part of the psyche that provides immediate response to an instinct. This impulse and immediate response is one reason why the Id is also considered to be selfish.

Send a message explaining your
needs and Sara will reply soon.
Contact Sara