logo

Crowdly

BU6015 - Business Analytics

Шукаєте відповіді та рішення тестів для BU6015 - Business Analytics? Перегляньте нашу велику колекцію перевірених відповідей для BU6015 - Business Analytics в moodle.polytechnic.bh.

Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!

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?
Переглянути це питання

Exploratory analytics includes which business analytics types?

Переглянути це питання

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.

Переглянути це питання
While Excel defaults to showing the data in a tabular format, Tableau defaults to showing the data in which of the following formats?
Переглянути це питання

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

Переглянути це питання

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

Переглянути це питання

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

Переглянути це питання

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.

Переглянути це питання
The typical order for getting data ready for analysis is as follows:
Переглянути це питання

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

Переглянути це питання

Хочете миттєвий доступ до всіх перевірених відповідей на moodle.polytechnic.bh?

Отримайте необмежений доступ до відповідей на екзаменаційні питання - встановіть розширення Crowdly зараз!