MA1 Excel Template Fa22 Van (2) (2) (1)

.xlsx

School

Grand Canyon University *

*We aren’t endorsed by this school

Course

105

Subject

Economics

Date

Apr 3, 2024

Type

xlsx

Pages

20

Uploaded by MinisterRatMaster657

Report
Competency Requirements for full credit Name Chart Conversions Income Analysis You have entered your full name in the field provided. (Note that entering your name on this sheet is required in order to complete your other sheets.) Best-Fit Line and Predicted Incomes You have correctly calculated the slope and y-intercept for the data provided, using appropriate Excel functions. Your formulas for Predicted Incomes are correct, using cell references for the slope, y-intercept, and years of education. Your slope, y-intercept, and Predicted incomes are formatted as indicated in the instructions. You have included an XY-Scatterplot of the BLS data, adding an appropriate title and axis labels. You have added a trendline to your scatterplot, extending it to 8 years on the left and 24 years on the right. Unit Conversions You have identified the correct units for your final quantity, using the units abbreviations (including capitalization) provided in the conversion factors table. You have identified the conversion ratios to use, using correct units abbreviations from the table (including capitalization) and adding an N/A entry if fewer than 3 conversions are needed. Your formulas for the ratios are correct, using appropriate cell references. Your final quantity formulas are correct and use cell references for all inputs. Fahrenheit / Celsius Conversions Your Fahrenheit to Celsius conversion formulas are correct and use cell references. The calculations are direct and do not use built-in Excel functions. You have entered the first two letters of your first and last names, using the letter M if one or both names consist of only one letter.
Currency Conversions Currency Conversions You have chosen appropriate countries from the list provided below the table, using the procedure described in the instructions. You have entered both the full name of your country's currency and the correct currency code as indicated on the website. You have provided each exchange rate to at least 5 significant digits, and the exchange rate matches the rate for the date you looked it up. The trip budget in the foreign currency is a correct Excel formula, using cell references. Your calculation of the value of 1000 of the foreign currency units into dollars is a correct Excel formula, using cell references. The cells containing the trip budget and value of 1000 units of foreign currency are correctly formatted as specified in the last column of the table.
Major Assignment 1 Grading Shee 1 24 68 19 24 8 Subtotals 144 0 8 20 40 32 16 Subtotals 116 0 4 (optional for student use) Did you meet the requirements? Points possible Your points
4 8 4 16 16 8 Subtotals 60 0 Totals 320 0 Percentage 100.00% 0.00% Scaled out of 125 125.00 0.00
et Scoring comments
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help