week 2 assignment 1: The Espresso Lane to Global Markets
January 13, 2021
Environmental Issue: Ocean Pollution in Southern California
January 13, 2021

Applied Numerical Analysis Excel Assignment

5 Problems

Problem 1

Create a function that will have a numerical grade as an input and output the corresponding letter grade according to the scale below.

Problem 2

Create a subroutine that will create a 10 x 10 times table (4 x 4 example below) on an excel worksheet using at least one for loop.

Problem 3

Create a function for linear interpolation between two points according to the formula below where x, x1, x2, y1, and y2 will be inputs to the function.

= 2 − 1 ( − 1) + 1 2 − 1

Problem 4

Find the trend line for the following data (must show chart).

Problem 5

Create a subroutine that will output to a spreadsheet the minimum, maximum, average, and median of the input data below.

“Get 15% discount on your first 3 orders with us”
Use the following coupon
FIRST15

Order Now

Place Order

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp