Problem solving Assignment- Financial Management

Problem solving Assignment- Financial Management

Thank you for reading this post, don't forget to subscribe!

QUESTION 1

1. You have US census figures for population by year, income bracket, and state. You want to see a 2 dimensional table of just income bracket and state for the calendar year 2000. Which OLAP operation would you use?
2. pivot/Rotate
drill Down
roll Up
slice

none of the given choices describe this
0.9 points
QUESTION 2

1. Suppose you were looking at a set of sales figures where the X-axis was Customer Name and the Y-axis was Product Name. You instead want to see sales figures by Year and Product. Which operation would you perform?
2. pivot/Rotate
drill Down
roll Up
Slice
none of the given choices describe this
0.9 points

QUESTION 3: Problem solving Assignment- Financial Management

1. Suppose we had a database with a sales fact table related to a product dimension table and a date dimension table by identification keys. The product dimension table is further related to a product category table. Which of the following most accurately describes this schema?
2. Star
Snowflake
Both of the given choices
None of the given choices
1.4 points
QUESTION 4
1. Power Pivot-driven PivotTables will allow you to create Calculated Fields.
True
False
0.9 points
QUESTION 5
1. When working with a Power Pivot-driven PivotTable you can use the Slicer tool or the Filter to filter data.
True
False
0.9 points
QUESTION 6
1. In the brewery.xlsx file, which of the following is the primary index key for table6?
2. Location Name
Location ID
Product ID
State
City
1.4 points
QUESTION 7
1. Use the Brewery.xlsx file to answer the following question: How much total cost do American Pale Ales account for at Beerland Boston?
2. 2617.4
2127.5
4390
1815
3300.5
0.9 points
QUESTION 8
1. Use the Brewery.xlsx file to answer the following question: What’s the name of the product with the highest total revenue?
2. Black Manatee
Evil Squid
Bruin
Extended Puppy
Rearview
0.9 points
QUESTION 9
1. Use the Brewery.xlsx file to answer the following question: By revenue, what percent of Red Ales were sold in New Haven? (rounded to 2 decimals)
2. 18.59%
57.28%
23.04%
30.00%
20.95%
1.4 points
QUESTION 10
1. Which button in the Power Pivot Home Ribbon allows you to load data from a text file?
2. From Database
From Data Service
From Other Sources
Existing Connections
None of the Above
0.9 points
QUESTION 11
1. Which button in the Power Pivot Home Ribbon allows you to load data from an external excel file?
2. From Database
From Data Service
From Other Sources
Existing Connections
None of the Above
0.9 points
QUESTION 12
1. Using the file ImportText.txt, what is the sum of the TransPrice column?

QUESTION 1
1. Using the following URL of http://finance.yahoo.com/quote/GOOG/history, determine the average volume for shares of Google in 2020. Use the following parameters:
Time Period: 12/31/2019- 12/30/2020
Show: Historical Prices
Frequency: Weekly
(Round the answer to whole number)
0.9 points
QUESTION 2
1. Using the following URL, determine the average yield of a Long Term Treasure Bill (LT Composite>10yrs) in 2010:
https://home.treasury.gov/resource-center/data-chart-center/interest-rates/TextView?type=daily_treasury_real_long_term&field_tdr_date_value=all
Under the Resource Center, select “Daily Treasury Real Long-Term Rate Averages”
Select type of Interest Rate Data: Daily Treasury Real Long-Term Rates
Select Time Period: 2010
1.72
1.73
1.74
1.75
1.76
0.9 points
QUESTION 3
1. Using the following URL of http://finance.yahoo.com/quote/AMZN/history, determine the average difference between the weekly high and low for shares of Amazon in 2020. Use the following parameters:
Time Period: 12/31/2019- 12/30/2020
Show: Historical Prices
Frequency: Weekly
(Round the answer to 2 decimal places.)
1.4 points
QUESTION 4
1. Use the Brewery.xlsx file to answer the following question: What percentage of profit does Lager account for among the three types of beer? (rounded to 2 decimals)
2. 26.13%
52.00%
25.68%
14.25%
13.76%
0.9 points
QUESTION 5
1. Use the Brewery.xlsx file to answer the following question: Which type of beer accounts for the most total profit?
2. Cider
Lager
Ale
IPA
Pilsner
0.9 points
QUESTION 6
1. Use the Brewery.xlsx file to answer the following question: Across all four locations, what percentage of total profit is made in MA?
75.69%
81.00%
45.26%
74.56%
84.29%

 

 

ImportText

TransID,ProductID,TransCost,TransPrice,,

10001,1021,”$3,257″,”$3,976″,,

10002,1022,”$7,590″,”$8,398″,,

10003,1011,”$8,266″,”$8,782″,,

10004,1018,”$9,023″,”$9,620″,,

10005,1008,”$2,189″,”$2,650″,,

10006,1014,”$4,216″,”$4,473″,,

10007,1002,”$4,571″,”$4,805″,,

10008,1002,”$1,592″,”$2,434″,,

10009,1021,$918,”$1,794″,,

10010,1004,”$1,121″,”$1,628″,,

10011,1019,”$2,850″,”$3,264″,,

10012,1014,”$9,234″,”$10,026″,,

10013,1020,”$4,658″,”$4,791″,,

10014,1005,”$5,086″,”$5,783″,,

10015,1005,”$9,029″,”$9,285″,,

10016,1001,”$2,160″,”$2,927″,,

10017,1025,”$2,229″,”$2,739″,,

10018,1020,”$7,332″,”$8,030″,,

10019,1014,”$8,778″,”$9,496″,,

10020,1014,”$2,299″,”$2,421″,,

10021,1016,”$3,199″,”$3,601″,,

10022,1004,”$8,359″,”$8,484″,,

10023,1023,”$9,401″,”$10,154″,,

10024,1020,”$6,250″,”$6,983″,,

10025,1023,”$5,315″,”$6,309″,,

10026,1004,”$8,284″,”$8,506″,,

10027,1020,$403,”$1,329″,,

10028,1012,”$9,557″,”$10,277″,,

10029,1002,”$4,833″,”$5,226″,,

10030,1020,”$3,557″,”$3,821″,,

10031,1009,”$4,853″,”$5,195″,,

10032,1006,”$6,331″,”$7,173″,,

10033,1010,”$4,810″,”$4,939″,,

10034,1013,”$8,420″,”$8,923″,,

10035,1023,”$7,813″,”$8,478″,,

10036,1009,”$4,210″,”$4,925″,,

10037,1016,”$7,883″,”$8,778″,,

10038,1023,”$8,937″,”$9,120″,,

10039,1009,”$4,024″,”$4,855″,,

10040,1012,”$4,560″,”$5,141″,,

10041,1022,”$4,395″,”$4,645″,,

10042,1018,”$5,615″,”$5,811″,,

10043,1020,”$8,050″,”$8,823″,,

10044,1021,”$3,660″,”$3,915″,,

10045,1004,”$1,594″,”$2,593″,,

10046,1025,”$1,172″,”$1,854″,,

10047,1018,”$2,313″,”$2,826″,,

10048,1017,”$2,722″,”$3,585″,,

10049,1008,”$7,091″,”$7,574″,,

10050,1009,”$8,945″,”$9,451″,,

10051,1023,”$8,063″,”$8,563″,,

10052,1011,”$9,812″,”$10,120″,,

10053,1008,”$2,067″,”$2,845″,,

10054,1021,”$7,190″,”$7,330″,,

10055,1007,”$1,231″,”$2,190″,,

10056,1011,”$2,692″,”$3,391″,,

10057,1007,”$9,554″,”$10,240″,,

10058,1016,”$1,548″,”$2,248″,,

10059,1011,”$5,658″,”$6,068″,,

10060,1004,”$8,187″,”$8,665″,,

10061,1008,”$7,455″,”$8,380″,,

10062,1014,”$6,600″,”$6,837″,,

10063,1010,”$4,282″,”$4,739″,,

10064,1009,”$8,180″,”$8,353″,,

10065,1010,”$3,760″,”$3,861″,,

10066,1021,”$3,176″,”$3,383″,,

10067,1010,”$6,448″,”$7,269″,,

10068,1015,”$3,779″,”$4,197″,,

10069,1021,”$8,595″,”$9,163″,,

10070,1005,”$8,583″,”$9,289″,,

10071,1003,”$4,189″,”$5,014″,,

10072,1014,”$9,342″,”$10,201″,,

10073,1011,”$1,910″,”$2,559″,,

10074,1017,”$8,237″,”$9,006″,,

10075,1018,”$2,247″,”$2,439″,,

10076,1022,”$8,709″,”$9,568″,,

10077,1007,”$9,103″,”$9,752″,,

10078,1002,”$7,820″,”$8,209″,,

10079,1012,”$6,269″,”$6,882″,,

10080,1014,”$5,956″,”$6,581″,,

10081,1005,”$3,461″,”$4,361″,,

10082,1009,”$5,455″,”$6,301″,,

10083,1001,”$3,585″,”$3,739″,,

10084,1008,$571,”$1,288″,,

10085,1015,”$2,394″,”$3,020″,,

10086,1018,”$3,734″,”$4,691″,,

10087,1022,”$4,622″,”$4,911″,,

10088,1010,”$4,045″,”$5,006″,,

10089,1017,”$9,280″,”$9,529″,,

10090,1002,”$9,319″,”$9,478″,,

10091,1015,”$1,624″,”$1,764″,,

10092,1020,”$2,410″,”$3,167″,,

10093,1022,”$1,030″,”$1,927″,,

10094,1016,”$6,526″,”$7,173″,,

10095,1002,”$2,068″,”$2,851″,,

10096,1008,”$9,017″,”$9,982″,,

10097,1013,$987,”$1,727″,,

10098,1007,”$6,909″,”$7,633″,,

10099,1017,”$8,934″,”$9,148″,,

10100,1025,”$7,663″,”$8,590″,,

Problem solving Assignment- Financial Management

 

Get a 5 % discount on an order above $ 20
Use the following coupon code :
topwritersleague