logo

Crowdly

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!

Based on this scatterplot visualization from Lab 5.1 Excel, Evaluating the Relationship Between Sales and R&D Expenditures, which would you consider to be the independent variable?

The y axis ranges from 0 to 70000000 and the x axis ranges from 0 to 4000000. A dotted line representing lineat revenues rises from about (1000000, 17500000) to (4000000, 45000000). The dots are concentrated between 1000000 and 3000000 on the x axis and 20000000 and 40000000 on the y axis.

View this question

Which data type would Facebook, Twitter and Instagram post data generally be considered to be?

View this question
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?
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

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

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

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