Question: Write one expression using dplyr functions and the %>% operator to create the summary table below, and arrange it based on the customer state. This

Write one expression using dplyr functions and the %>% operator to create the summary table below, and arrange it based on the customer state. This table contains the number of claims, maximum claim amount (total_claim_amount variable), and minimum customer lifetime value by customer_state and months_since_last_claim binned into 12 month categories. Hint: You will need to create the month_category variable using cut_width() before you calculate the summaries by groups. ## `summarise()` has grouped output by 'customer_state'. You can override using the ## `.groups` argument

Results:

## `summarise()` has grouped output by 'customer_state'. You can override using the ## `.groups` argument. ## # A tibble: 15 x 5 ## # Groups: customer_state [5] ## customer_state month_category n_claims max_claim_amount min_clv ## ## 1 Arizona [0,12] 553 3893. 2227. ## 2 Arizona (12,24] 365 3295. 2255. ## 3 Arizona (24,36] 263 2550. 2309. ## 4 Nevada [0,12] 260 2979. 2227. ## 5 Nevada (12,24] 202 2337. 2329. ## 6 Nevada (24,36] 139 3552. 2523. ## 7 California [0,12] 977 3453. 2120. ## 8 California (12,24] 712 2767. 2301. ## 9 California (24,36] 461 2361. 2392. ## 10 Oregon [0,12] 824 2836 2227. ## 11 Oregon (12,24] 569 2973. 2280. ## 12 Oregon (24,36] 370 3052 2174. ## 13 Washington [0,12] 241 2966. 2227. ## 14 Washington (12,24] 195 2429. 2301. 1 ## 15 Washington (24,36] 118 2685. 2472.

Please tell me how to sove this problem using R studio.

I need to follow the instructions to make the results

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!