logo

Crowdly

Browser

Add to Chrome

BU6015 - Business Analytics

Looking for BU6015 - Business Analytics test answers and solutions? Browse our comprehensive collection of verified answers for BU6015 - Business Analytics at moodle.polytechnic.bh.

Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!

InLab 6.4 Excel, Descriptive Analytics: Creating a Dashboard Using Pivot Tables and Slicers, you added different levels of slicers. Which Excel option did you use to determine which of the pivot tables that a slicer would work on?
0%
0%
0%
0%
View this question

Exploratory analytics includes which business analytics types?

✅
❌
❌
❌
View this question

Based on this pivot table in Lab 1.3 Excel, Assessing Product (SKU) Profitability, which product number is the most profitable per dollar of sales?

S K U, description, sales price per pound, cost per pound, gross margin, and gross margin percentage are the column heads of the pivot table with dropdown buttons. The row entries are as follows: F R T hyphen S A R, salal berry, 1.12, 0.66, 0.46, and 0.411. F R T hyphen R E N, redcurrant, 1.42, 0.85, 0.57, and 0.401. F R T hyphen A V D, avocado, 1, 0.59, 0.41, and 0.410. F R T hyphen P U E, purple mangos, 1.01, 0.59, 0.42, and 0.416. F R T hyphen B I T, bilberty, 2, 1.17, 0.83, and 0.415. F R T hyphen P L T, plumcot, 2.1, 1.24, 0.86, and 0.410. F R T hyphen B L N, blackcurrent, 2, 1.18, 0.82, and 0.410. F R T hyphen P I L, pineapple, 0.77, 0.46, 0.31, and 0.403. F R T hyphen P L M, plumprune, 1.31, 0.77, 0.54, and 0.412. F R T hyphen C U N, currant, 1.75, 1.04, 0.71, and 0.406. F R T hyphen P E A, pear, 1.83, 1.07, 0.76, and 0.415. F R T hyphen P A Y, papaya, 1.06, 0.63, 0.43, and 0.406. F R T hyphen C H I, chico fruit, 1.75, 1.03, 0.72, and 0.411. F R T hyphen M I I, miracle fruit, 2.05, 1.2, 0.85, and 0.415. F R T hyphen L O A, Longan, 1.85, 1.1, 0.75, and 0.405. F R T hyphen L I M, lime, 0.96, 0.57, 0.39, and 0.406. F R T hyphen C U E, cucumber, 1.82, 1.09, 0.73, and 0.401. F R T hyphen K I I, kiwifruit, 2.32, 1.37, 0.95, and 0.409. F R T hyphen J A U, jambul, 1.95, 1.13, 0.82, and 0.421. F R T hyphen J A I, jackfruit, 0.63, 0.37, 0.26, and 0.413. F R T hyphen J A B, jabuticaba, 0.89, 0.52, 0.37, and 0.416. F R T hyphen G U V, guava, 0.94, 0.56, 0.38, and 0.404. F R T hyphen G R I, graperaisin, 1.25, 0.74, 0.51, and 0.408.

❌
✅
❌
❌
View this question
While Excel defaults to showing the data in a tabular format, Tableau defaults to showing the data in which of the following formats?
❌
❌
❌
✅
View this question

Based on these regression results from Lab 5.2 Excel, Evaluating the Relationship Between Sales and R&D Expenditures: Testing for a Nonlinear Relationship, how can the relationship between sales and R&D be best explained?

Under regression statistics, the following values are shown: Multiple R, 0.909478. R square, 0.827151. Adjusted R square, 0.823859. Standard error, 6030121. Observations, 108. In the ANOVA table at the center, values are shown as follows: Regression: d f, 2. S S, 1.82709E + 16. M S, 9.14E + 15. F, 251.2333. Significance F, 9.49532E minus 41. Residual: d f, 105. S S, 3.81805E + 15. M S, 3.64E + 13. Total: d f, 107. S S, 2.20889E + 16 In the table at the bottom, the entries are shown as follows: Intercept: Coefficients, 21367225. Standard error, 2269617.303. t Stat, 9.414462. P value, 1.26E minus 15. Lower 95 percent, 16866993.19. R and D expenditures: Coefficients, 5.501598. Standard error, 1.980307943. t Stat, 2.778153. P value, 0.006477. Lower 95 percent, 1.575013356. R and D expenditures squared: Coefficients, 1.31E minus 06. Standard error. 3.89595E-07. t Stat, 3.351151. P value, 0.001119. Lower 95 percent, 5.33096E minus 07

0%
0%
0%
0%
View this question

Veracity evaluates whether the data is accurate (and clean), worthy of trust and:

❌
✅
❌
❌
View this question

Which step of the SOAR model would usually involve computing an average?

❌
✅
❌
❌
View this question

Based on Lab 2.4 Excel: Aggregating and Visualizing Different Data Types, given this key and this visualization, what does the slicer allow you to see?

The excel sheet shows the sales order quantity sold, a horizontal bar graph representing the data, and a list of states. The top left section of the excel sheet shows a table with 4 columns and 9 rows. The headings in columns 1 and 2 are as follows: sun of sales_order_quantity_sold; column labels. The heading in column 2 is selectable. The sub-headings in columns 1 to 4 are as follows: row labels; 2024; 2025; grand total. The row entries are as follows: row 3 - imperial stout; 92; 166; 258. Row 4 - I P A; 64; 183; 247. Row 5 - stout; 72; 118; 190. Row 6 - pale ale; 35; 81; 116. Row 7 - wheat; 33; 74; 107. Row 8 - imperial I P A; 19; 42; 61. Row 9 - grand total; 315; 664; 979. The horizontal bar graph on the right shows the data of the sum of sales order quantity sold with the following drop down menu selected: prodcut_description. On the right he years drop down menu is selected. Below is a list of the customer states with a vertical scroll bar on the right.

❌
✅
❌
❌
View this question
The typical order for getting data ready for analysis is as follows:
❌
❌
✅
❌
View this question

Which type of visualization is used in communicating the findings of the analysis to interested stakeholders?

✅
❌
❌
❌
View this question

Want instant access to all verified answers on moodle.polytechnic.bh?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Browser

Add to Chrome

TelegramInstagramTikTokQuestion Bank
Terms of UseContact Us