使用MATLAB拟合竞价与曝光次数关系曲线并进行模型评估

%20%E8%AF%BB%E5%8F%96Excel%E6%95%B0%E6%8D%AE%0Adata%20%3D%20xlsread(%27Impression%26%26CPC.xlsx%27%2C%20%27Sheet1%27%2C%20%27A2%3AB212%27)%3B%20%25%20%E5%81%87%E8%AE%BE%E6%95%B0%E6%8D%AE%E5%9C%A8Sheet1%E4%B8%AD%EF%BC%8C%E6%9B%9D%E5%8F%91%E6%AC%A1%E6%95%B0%E5%9C%A8%E7%AC%AC%E4%B8%80%E5%88%97%EF%BC%8C%E7%AB%9E%E4%BB%B7%E5%9C%A8%E7%AC%AC%E4%BA%8C%E5%88%97%0A%0Aimpressions%20%3D%20data(:,%201)%3B%20%25%20%E6%9B%9D%E5%8F%91%E6%AC%A1%E6%95%B0%E6%95%B0%E6%8D%AE%0Abid%20%3D%20data(:,%202)%3B%20%25%20%E7%AB%9E%E4%BB%B7%E6%95%B0%E6%8D%AE%0A%0A%25%20%E6%89%BE%E5%88%B0%E7%A9%BA%E4%BD%8D%E7%BD%AE%E7%9A%84%E7%B4%A2%E5%BC%95%0Amissing_idx%20%3D%20isnan(impressions)%20%7C%20isnan(bid)%3B%0A%0A%25%20%E5%B0%86%E7%A9%BA%E4%BD%8D%E7%BD%AE%E5%A1%AB8%E5%85%A5%E4%B8%AD%E4%BD%8D%E6%95%B0%0Aimpressions(missing_idx)%20%3D%20median(impressions(~missing_idx))%3B%0Abid(missing_idx)%20%3D%20median(bid(~missing_idx))%3B%0A%0A%25%20%E7%94%BB%E5%87%BA%E6%95%A3%E7%82%B9%E5%9B%BE%0Ascatter(bid,%20impressions)%3B%0Axlabel(%27%E7%AB%9E%E4%BB%B7%27)%3B%0Aylabel(%27%E6%9B%9D%E5%8F%91%E6%AC%A1%E6%95%B0%27)%3B%0Atitle(%27%E7%AB%9E%E4%BB%B7%E4%B8%8E%E6%9B%9D%E5%8F%91%E6%AC%A1%E6%95%B0%E5%85%B3%E7%B3%BB%E6%95%A3%E7%82%B9%E5%9B%BE%27)%3B%0A%0A%25%20%E5%AE%9A%E4%B9%89%E6%A8%A1%E5%9E%8B%E5%87%BD%E6%95%B0%0Amodel%20%3D%20%40(x,%20bid)%20x(1)%20*%20exp(x(2)%20*%20(x(3)%20*%20bid%20+%20x(4)))%20.%20sin(2pi*x(5)bid)%3B%0A%0A%25%20%E5%AE%9A%E4%B9%89%E8%AF%AF%E5%85%B0%E5%87%BD%E6%95%B0%EF%BC%88%E6%9C%80%E5%B0%8F%E4%BA%8C%E7%A7%B0%E6%B3%95%EF%BC%89%0AerrorFunc%20%3D%20%40(x)%20sum((model(x,%20bid)%20-%20impressions).^2)%3B%0A%0A%25%20%E5%88%9D%E5%A7%8B%E5%8F%82%E6%95%B0%E5%80%BC%0Ax0%20%3D%20[1,%200.1,%200.1,%200.1,%200.1]%3B%0A%0A%25%20%E4%BD%BF%E7%94%A8fminsearch%E5%87%BD%E6%95%B0%E8%BF%9B%E8%A1%8C%E5%8F%82%E6%95%B0%E4%BC%B0%E8%AE%A1%0Ax%20%3D%20fminsearch(errorFunc,%20x0)%3B%0A%0A%25%20%E8%BE%93%E5%87%BA%E4%BC%B0%E8%AE%A1%E7%9A%84%E5%8F%82%E6%95%B0%E5%80%BC%0Aa%20%3D%20x(1)%3B%0Ab%20%3D%20x(2)%3B%0Ac%20%3D%20x(3)%3B%0Ad%20%3D%20x(4)%3B%0AT%20%3D%20x(5)%3B%0A%0A%25%20%E6%89%93%E5%8D%B0%E5%8F%82%E6%95%B0%E5%80%BC%0Afprintf(%27%E4%BC%B0%E8%AE%A1%E7%9A%84%E5%8F%82%E6%95%B0%E5%80%BC%EF%BC%9A%5Cn%27)%3B%0Afprintf(%27a%20%3D%20%.2f%5Cn%27,%20a)%3B%0Afprintf(%27b%20%3D%20%.2f%5Cn%27,%20b)%3B%0Afprintf(%27c%20%3D%20%.2f%5Cn%27,%20c)%3B%0Afprintf(%27d%20%3D%20%.2f%5Cn%27,%20d)%3B%0Afprintf(%27T%20%3D%20%.2f%5Cn%27,%20T)%3B%0A%0A%25%20%E4%BB%A3%E5%85%A5%E5%8F%82%E6%95%B0%E7%BB%98%E5%88%B6%E6%9B%B2%E7%BA%BF%E5%9B%BE%EF%BC%88%E5%8C%85%E6%8B%AC%E6%8E%92%E9%99%A4%E5%A1%AB8%E5%85%A5%E6%95%B0%E6%8D%AE%E5%90%8E%E7%9A%84%E6%95%A3%E7%82%B9%E5%9B%BE%EF%BC%89%0Ax_vals%20%3D%20linspace(min(bid),%20max(bid),%20100)%3B%20%25%20%E7%94%9F%E6%88%90%E6%A8%AA%E5%8F%8D%E5%8F%8D%E6%95%B0%E6%8D%AE%0Ay_vals%20%3D%20model(x,%20x_vals)%3B%20%25%20%E8BA%8F%E7%AE%97%E7%AD%96%E5%8F%8D%E5%8F%8D%E6%95%B0%E6%8D%AE%0A%0Afigure%3B%20%25%20%E5%88%9B%E5%BB%BA%E6%96%B0%E7%9A%84%E5%9B%BE%E5%BD%A2%E7%AA%97%E5%8F%A3%0Ascatter(bid,%20impressions)%3B%20%25%20%E7%BB%98%E5%88%B6%E5%8E%9F%E5%A7%8B%E6%95%B0%E6%8D%AE%E7%9A%84%E6%95%A3%E7%82%B9%E5%9B%BE%0Ahold%20on%3B%0Ascatter(bid(~missing_idx),%20impressions(~missing_idx),%20%27filled%27,%20%27MarkerFaceColor%27,%20%27r%27)%3B%20%25%20%E7%BB%98%E5%88%B6%E6%8E%92%E9%99%A4%E5%A1%AB8%E5%85%A5%E6%95%B0%E6%8D%AE%E5%90%8E%E7%9A%84%E6%95%A3%E7%82%B9%E5%9B%BE%0Aplot(x_vals,%20y_vals,%20%27g--%27,%20%27LineWidth%27,%202)%3B%20%25%20%E7%BB%98%E5%88%B6%E6%9C%80%E4%BD%B3%E6%9C%80%E5%90%88%E6%9B%B2%E7%BA%BF%0A%0Axlabel(%27%E7%AB%9E%E4%BB%B7%27)%3B%0Aylabel(%27%E6%9B%9D%E5%8F%91%E6%AC%A1%E6%95%B0%27)%3B%0Atitle(%27%E7%AB%9E%E4%BB%B7%E4%B8%8E%E6%9B%9D%E5%8F%91%E6%AC%A1%E6%95%B0%E5%85%B3%E7%B3%BB%E6%95%A3%E7%82%B9%E5%9B%BE%E5%8F%8A%E6%9C%80%E4%BD%B3%E6%9C%80%E5%90%88%E6%9B%B2%E7%BA%BF%27)%3B%0Alegend(%27%E5%8E%9F%E5%A7%8B%E6%95%B0%E6%8D%AE%27,%20%27%E6%8E%92%E9%99%A4%E5%A1%AB8%E5%85%A5%E6%95%B0%E6%8D%AE%E5%90%8E%E7%9A%84%E6%95%B0%E6%8D%AE%27,%20%27%E6%9C%80%E4%BD%B3%E6%9C%80%E5%90%88%E6%9B%B2%E7%BA%BF%27)%3B%0A%0A%0A%25%20%E968F%E6%9C%BA%E9%80%89%E5%8F%96%E8%AE%AD%E7%B1%B3%E9%9B%86%E5%92%8C%E6%B8%AC%E8%AF%95%E9%9B%86%E7%9A%84%E7%B4%A2%E5%BC%95%0An%20%3D%20size(data,%201)%3B%20%25%20%E6%95%B0%E6%8D%AE%E6%80%BB%E6%95%B0%0Atrain_ratio%20%3D%200.8%3B%20%25%20%E8%AE%AD%E7%B1%B3%E9%9B%86%E6%AF%94%E4%BE%8B%0Atrain_idx%20%3D%20randperm(n,%20round(train_ration))%3B%20%25%20%E968F%E6%9C%BA%E9%80%89%E5%8F%96%E8%AE%AD%E7%B1%B3%E9%9B%86%E7%B4%A2%E5%BC%95%0Atest_idx%20%3D%20setdiff(1%3An,%20train_idx)%3B%20%25%20%E5%89%A9%E4%BD%8D%E7%9A%84%E7%B4%A2%E5%BC%95%E4%B8%BA%E6%B8%AC%E8%AF%95%E9%9B%86%E7%B4%A2%E5%BC%95%0A%0A%25%20%E6%8C%89%E7%B4%A2%E5%BC%95%E83B7%E5%8F%96%E8%AE%AD%E7%B1%B3%E9%9B%86%E5%92%8C%E6%B8%AC%E8%AF%95%E9%9B%86%E6%95%B0%E6%8D%AE%0Atrain_data%20%3D%20data(train_idx,%20:)%3B%0Atest_data%20%3D%20data(test_idx,%20:)%3B%0A%0A%25%20%E83B7%E5%8F%96%E8%AE%AD%E7%B1%B3%E9%9B%86%E5%92%8C%E6%B8%AC%E8%AF%95%E9%9B%86%E7%9A%84%E6%9B%9D%E5%8F%91%E6%AC%A1%E6%95%B0%E5%92%8C%E7%AB%9E%E4%BB%B7%E6%95%B0%E6%8D%AE%0Atrain_impressions%20%3D%20train_data(:,%201)%3B%0Atrain_bid%20%3D%20train_data(:,%202)%3B%0Atest_impressions%20%3D%20test_data(:,%201)%3B%0Atest_bid%20%3D%20test_data(:,%202)%3B%0A%0A%25%20%E6%89%93%E5%8D%B0%E8%AE%AD%E7%B1%B3%E9%9B%86%E5%92%8C%E6%B8%AC%E8%AF%95%E9%9B%86%E7%9A%84%E6%95%B0%E9%87%8F%0Afprintf(%27%E8%AE%AD%E7%B1%B3%E9%9B%86%E6%95%B0%E9%87%8F%EF%BC%9A%25d%5Cn%27,%20numel(train_idx))%3B%0Afprintf(%27%E6%B8%AC%E8%AF%95%E9%9B%86%E6%95%B0%E9%87%8F%EF%BC%9A%25d%5Cn%27,%20numel(test_idx))%3B%0A