Enable contrast version

# Tutor profile: Clayton E.

Inactive
Clayton E.
Design Engineer
Tutor Satisfaction Guarantee

## Questions

### Subject:Microsoft Excel

TutorMe
Question:

My boss has given me a spreadsheet that has roughly 1000 rows in it. Column A lists all of the part numbers that our facility makes, and Column B lists the corresponding profits per part number. He has given me the task of figuring out the total price of any part number that contains "A100" in it; however, many of the parts contain this section of the part number in various parts. For example, we have one part number that is XFZA100435 and another part that is A10045662. Is there a way I can pick out "A100" and sum up the total profits from all of these values?

Inactive
Clayton E.

Rest assured, there is an easy way to find your solution and to make your boss a happy camper. For this problem, we will be using the SUMIF function. Excel has a function that will allow you to sum certain values, only if a certain criteria has been met. The SUMIF function looks like this. SUMIF(range,criteria,[sum_range]), where range is the range of numbers that is to be evaluated, criteria is the specific values you are looking for, and [sum_range] is the range that is going to be added together. In a cell below your total profits, type the function =SUMIF(). Now for the range, you will be selecting the entire column of part numbers. These are the values that you are sorting through. For the criteria, you will need to add in what you are searching for. In your case, you need to sort through which part numbers have a "A100" value in it; however, we can't simply use this value in the function. If you put just that value, it will only return part numbers that only have the string A100 in it. Instead, we need to use a wildcard command that will search each part number for that specific number in it. To do this, surround the criteria with asterisks. You'll also have to use quotations around the wild card so Excel sees this value as a string and not an integer. If you leave it without the quotes, the function won't return the value you want and will give an error flag. Finally, we need to enter the sum range, or the range that will be summed. These are the total profit values in column B. Your equation should look something like this. =SUMIF(A1:A1000, "*A100*", B1:B1000). This will give you the desired result.

### Subject:Pre-Calculus

TutorMe
Question:

Predict the effect on the graph of the function f(x) = x^2 in graphing (a) y = f(x-1) -2 (b) y = -f(x+2)

Inactive
Clayton E.

Although transformed graphs seem intimidated, they're pretty okay after you practice a few of them. Let's look at (a) first. For this function, you would replace x with (x-1). This gives you an equation of y = (x-1)^2 - 2. We know that y = x^2 is a parabola, so this shape of this graph will look similar, assuming the transformations doesn't shift it too much. When you look at the section (x-1), we can see that the graph is shifted to the right by one unit. This means the whole parabola will shift to the right by one. Now when we take a look at -2, we can see that the graph will shift down by two units. So overall, the graph will shift to the right by one, and down by 2. The low point or bottom of the parabola will be at (1, -2). Now let's take a look at (b). y = -f(x+2). When we substitute in the function, we are left with the equation y = - (x+2)^2. Again, this graph will also take a form of a parabola since we are substituting in an x^2. Take a look at the (x+2). The +2 tells us that the parabola will be shifted to the left by 2 units. So when you plot it, the graph will be a simple parabola that is shifted to the left by two units, with a low point at (-2,0). But what about that "-" sign in front of the function? Well, this means that the parabola, or function, is negative and all we have to do now is reflect the graph across the x axis. The final result will be a parabola shifted to the left two units that is opening down, or making a frowny face.

### Subject:Algebra

TutorMe
Question:

The rate to rent a small moving van is \$30 per day, plus \$0.50 per mile. Jada rented a van to drive to her new home. It took two days, and the van cost \$360. How many miles did she drive?

Inactive
Clayton E.

## Contact tutor

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